Forum Discussion
Need help creating a formula
I need some help creating a formula (not that good at excel at the moment). Section A: In the transfer section I need a formula (I think a countifs one) that will see the information in section ...
=COUNTIFS($A$10:$A$15,A3,$B$10:$B$15,"Transfer")This can be done with COUNTIFS as you mentioned.
=SUMPRODUCT(($A$10:$A$15=A3)*($B$10:$B$15="Transfer"))An alternative could be SUMPRODUCT.