Thread: Count Cells where text may contain a specific word
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
  
Posts: 9,101
Default Count Cells where text may contain a specific word
=sumproduct(--(instr(G2:G2000,"DSMB")0))

"Vic" wrote:

I need to count (text or general) cells G2 thru G2000 if the text contains
the following word DSMB - combination of 4 charachters All Caps. How do I do
this? The word DSVB may be at the beginning, middle or the end of sentence.
No specific position.
Thank you.
Reply With QuoteReply With Quote