Multiple IF AND statement function

T

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.
 
M

Mark Graesser

Tammy
You can use SUMPRODUCT for this

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

Good Luck
Mark Graesse
[email protected]

----- 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
 
Top