Thread: COUNTIF quandry
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KL KL is offline
external usenet poster
  
Posts: 201
Default COUNTIF quandry
Upps! I guess I misunderstood the question...

"KL" wrote
If you need to count either those that include "Station 1" or those that
include "F", then:

=SUMPRODUCT(COUNTIF(SWABS!F7:F237,{"*Station 1*","*F*"}))

KL
Reply With QuoteReply With Quote