Forum Discussion
Solved
Creating a Formula
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 th...
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)
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)