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