Countif - Key words

  • Thread starter Thread starter PAL
  • Start date Start date
P

PAL

I have multi-column, multi row spreadsheet. One of the columns is for a
title. Is there a way to do a count of "key words". I was thinking like
countif. Using a key word, perhaps with a wildcard.

For example, how many titles have the word, "Extension".

Thanks.
 
Thanks.

Is there a way to tweak this to do the following:

Count all titles that had the words, "normal" AND/OR "healthy".
 
Hi,

Try this. D7:D11 is the range and C14:C15 holds Normal and Healthy

=SUMPRODUCT(1*(ISNUMBER(MATCH(D7:D11,C14:C15,0))))

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top