count text occurance in range

  • Thread starter Thread starter Stehy
  • Start date Start date
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 !
 
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
 
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
 
Back
Top