Countif - Key words
 

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.

Countif - Key words
 

=COUNTIF(A1:A100,"*Extension*")

--
Gary''s Student - gsnu200857

Countif - Key words
 

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

If this post helps click Yes
---------------
Jacob Skaria


"PAL" wrote:

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.

Countif - Key words
 

Thanks.

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

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

"Gary''s Student" wrote:

=COUNTIF(A1:A100,"*Extension*")

--
Gary''s Student - gsnu200857

Countif - Key words
 

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

"PAL" wrote in message
...
Thanks.

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

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

"Gary''s Student" wrote:

=COUNTIF(A1:A100,"*Extension*")

--
Gary''s Student - gsnu200857