Thread: Count string IF.....
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Harlan Grove[_2_] Harlan Grove[_2_] is offline
external usenet poster
  
Posts: 1,231
Default Count string IF.....
"Max" wrote...
One way:
=SUMPRODUCT((ISNUMBER(FIND({"WAP","RBT","MM4"},B2 :B5)))*(A2:A5="Joe"))
....

Another way, shorter but an array formula,

=COUNT(FIND({"WAP","RBT","MM4"},B2:B5)/(A2:A5="Joe"))


Reply With QuoteReply With Quote