count text occurance in range

S

Stehy

I am working in Excel 2003 and would like to enter a formula counting the
number of times a specific word (sometimes in a sentence) appears in a range
of cells. Does somebody know how ? Thank you !
 
E

Eduardo

Hi,
try

=COUNTIF(A10:A13,"aa*")

replace aa for the word you are looking for and change the range to fit your
needs
if this helps please click yes thanks
 
M

Mike H

Hi,

Try this but note it isn't bullet proof. For example I set it up to look for
'word' and it will pick up all instances of that string in the range
including if it appears twice or more in a cell. Where it is weak is it will
also count.

Wordy, words etc

=SUMPRODUCT((LEN(A1:A10)-(LEN(SUBSTITUTE(A1:A10,"word",""))))/LEN("word"))

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top