formula help

T

TMF in MN

A B
1 1 a7
2 2 a6
3 3 a6
4 3 a4

I would like a formula that counts how many times A:A =3 and B:B =a6
In this example, the answer is 1 THANK YOU
 
D

David Billigmeier

Sumproduct would be what you want, unfortunately it doesn't except entire
columns as input so you have to do something like the following:

=SUMPRODUCT(--(A1:A65535=3),--(B1:B65535="a6")) +
SUMPRODUCT(--(A65536=3),--(B65536="a6"))
 
Top