Counting String in a range

[encioman]

May I have a formula to count a specific string(word) in a range?

 

[RoryA]

Does it only appear once in any cell? If so, you can just use COUNTIF. If it appears more than once, you will need a combination of LEN and SUBSTITUTE. Both will be more complicated if you are searching for a word that might appear as part of another word that you don't want to include - e.g. you are searching for the word COUNT but one or more cells may contain the word COUNTDOWN and you don't want to include those.
So, basically, we need more information.