SOLVED

Creating a Formula

Copper Contributor

I need help in creating a formula. 

KMay03_0-1694461246709.png

Case Worker: Luna, Kris, Penny

Individuals applying: A,K (Adults, Kids)

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?

1 Reply
best response confirmed by KMay03 (Copper Contributor)
Solution

@KMay03 

For example:

HansVogelaar_0-1694463298605.png

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

@KMay03 

For example:

HansVogelaar_0-1694463298605.png

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)

View solution in original post