SOLVED

# Creating a Formula

Copper Contributor

# Creating a Formula

I need help in creating a formula.

Case Worker: Luna, Kris, Penny

For every application received, it is assigned to one of the case workers. They then track how many kids or adults (A, K) applying. How do I create a formula to show how many individuals applying for each cases/application assigned to each case workers?

Example: Kris wants to calculate the total individuals applying that was assigned to herself. In order to do that, she would have to manually calculate the total. How can Kris create a formula that every time, she enters the numbers of apps and individuals applying, the system will calculate for her?

best response confirmed by KMay03 (Copper Contributor)
Solution

# Re: Creating a Formula

For example:

In H2:

=SUMPRODUCT((\$A\$3:\$C\$8="x")*(\$A\$2:\$C\$2=\$H\$1)*\$D\$3:\$D\$8)

And in H3:

=SUMPRODUCT((\$A\$3:\$C\$8="x")*(\$A\$2:\$C\$2=\$H\$1)*\$E\$3:\$E\$8)

1 best response

Accepted Solutions
best response confirmed by KMay03 (Copper Contributor)
Solution

# Re: Creating a Formula

For example:

In H2:

=SUMPRODUCT((\$A\$3:\$C\$8="x")*(\$A\$2:\$C\$2=\$H\$1)*\$D\$3:\$D\$8)

And in H3:

=SUMPRODUCT((\$A\$3:\$C\$8="x")*(\$A\$2:\$C\$2=\$H\$1)*\$E\$3:\$E\$8)