adding words

[Osyris]

Hi everyone

this is my problem.

In a excel sheet there are many different words in several cells.
i want a way to add a spacific word and get the total number of times this
word appears in the sheet.
For example...
the word "office" appears many times in the sheet and i want a way to show
me how many times this word appears in number.

thanks..

 

[Toppers]

Try:

=COUNTIF(A120,"*office*")

change range to your requirements