Count Cells where text may contain a specific word
Try,
=COUNTIF(G2:G2000,"*DSMB*")
Mike
"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.
|