I a formula that outputs the number of occurances of a specific t.

A

Artem

I am trying find out a number that a specific word appears in a single
worksheet, is there an excell function that can do that?
 
H

Harlan Grove

Artem wrote...
I am trying find out a number that a specific word appears in a single
Click to expand...
worksheet, is there an excell function that can do that?
Click to expand...

=SUMPRODUCT((LEN(A1:Z1000)-LEN(SUBSTITUTE(A1:Z1000,YourWord,"")))
/LEN(YourWord))
 
Top