formula help
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"))
--
Regards,
Dave
"TMF in MN" wrote:
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
|