formula help

[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

[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"))
--
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