CountIf with AND

[Guest]

I want to count the number of cells that meet a specific criteria in two column ranges.
=COUNTIF(AND(E2:E62,"7th Avenue",B2:B62,"6A - 2P")
The error returned is "You've entered too few arguments for this function"

 

[Dave R.]

SUMPRODUCT((E2:E62="7th Ave")*(B2:B62="6a-2p"))

 

[Jason Morin]

Using COUNTIF and AND together is like asking a Shiite
Muslim and a Sunni Muslim to hug...it ain't gonna happen.
Try:

=SUMPRODUCT(--(E2:E62="7th Avenue"),--(B2:B62="6A - 2P"))

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks for the help. It worked.

 

[Guest]

Thanks for your help. This works too.