count frequency of a word in range of cells
 

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!
--
Thanks!

count frequency of a word in range of cells
 

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
"learningaccess" wrote in message
...
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!
--
Thanks!

count frequency of a word in range of cells
 

Try,

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

Mike

"learningaccess" wrote:

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!
--
Thanks!