Multiple IF AND statement function

[Tammy D]

I am looking for a formula that would look at the values
from various columns that meet a variety of criteria and
count the cells that meet that criteria. For example:
if b2:b9999=01/02/04 and c2:c9999=70 then count. Thanks.

 

[Mark Graesser]

Tammy
You can use SUMPRODUCT for this

example
=SUMPRODUCT((B2:B9999=DATE(2004,1,2))*(C2:C9999=70)

Good Luck
Mark Graesse
(e-mail address removed)

----- Tammy D wrote: ----

I am looking for a formula that would look at the values
from various columns that meet a variety of criteria and
count the cells that meet that criteria. For example:
if b2:b9999=01/02/04 and c2:c9999=70 then count. Thanks