count frequency of a word in range of cells

[learningaccess]

Hi.
I want to count the word "overachievement" in a range of cells. Problem
is, this word appears with other words in cells. Like "Overachievement Q1"
or "Overachievement bonus" or "overachievment growth". The word does not
stand alone.

Is there a way to use count or frequency function to do this? Please help.
Urgent!

 

[John]

hi
You received a response from Pete_UK yesterday; did you try it, it should work,
if not tell us what is happening.
HTH
John

 

[Mike H]

Try,

=COUNTIF(A1:H35,"*overachievement*")

Mike