Try this:

=COUNTIF(A1:A10,"*manager*")

Or, use a cell to hold the word:

B1 = manager

=COUNTIF(A1:A10,"*"&B1&"*")

--
Biff
Microsoft Excel MVP


"TYTQ" wrote in message
...
How to count the frequency of a word appearing in a range of data, even
the
word appears together with other word, i.e. "manager" and "assistant
manager". When criteria is set as "manager", and "assistant manager" will
also be counted. Thank you.