Using Countif with multiple criteria in the same column.

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

[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")

[Peo Sjoblom]

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



--
Regards,

Peo Sjoblom

(No private emails please)


"Harley" <[email protected]> wrote in message
news:[email protected]...
>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.