adding words
 

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..

adding words
 

Try:

=COUNTIF(A1:D20,"*office*")

change range to your requirements

"Osyris" wrote:

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..