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