Multiple IF AND statement function

  • Thread starter Thread starter Tammy D
  • Start date Start date
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.
 
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
 
Back
Top