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
 

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

Similar Threads

SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Counting occurences of text 3
Counting number of times name occurs between two dates 2
Count range of cells if not next to each other 0
Count the times a specific character appears in a cell 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
If >0, count various codes in a range on another sheet 8
Counting cells in a selectable date range 0

Back
Top