I need help in creating a formula.
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?
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)