Using Countif with multiple criteria in the same column.

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.

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

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



--
Regards,

Peo Sjoblom

(No private emails please)


"Harley" <Harley@discussions.microsoft.com> wrote in message
news:4CB4EA0E-A7DC-4454-8DC1-2676A874F2BD@microsoft.com...
>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.