Thread: Using Countif with multiple criteria in the same column.
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom
 
Posts: n/a
Default Using Countif with multiple criteria in the same column.


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



--
Regards,

Peo Sjoblom

(No private emails please)


"Harley" wrote in message
...
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.

Reply With QuoteReply With Quote