Using Countif with multiple criteria in the same column.

H

Harley

I need to count different criteria from the same column. For example, under
the column Names, the criteria for one breakout might be Tom, Beth, John,
Roger; the next breakout might be Joe, Sue, Randy, Bob.
 
R

rsenn

Assuming you want a count of "Ted" plus "Bob" you could use a formula
similar to this.

=COUNTIF(C14:C19,"Ted")+COUNTIF(C14:C19,"Bob")
 
P

Peo Sjoblom

=SUMPRODUCT(COUNTIF(A1:A10,{"Tom";"Beth";"John"}))



--
Regards,

Peo Sjoblom

(No private emails please)
 
Top