Countif - Key words

[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.

 

[Jacob Skaria]

=CountIF(A:A,"*xx*")

If this post helps click Yes

 

[PAL]

Thanks.

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

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

 

[Ashish Mathur]

Hi,

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

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com