From: Stehy on 7 Jan 2010 09:07 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 ! From: Eduardo on 7 Jan 2010 09:29 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 "Stehy" wrote: > 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 ! From: Mike H on 7 Jan 2010 09:38 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 "Stehy" wrote: > 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 ! From: Garyj on 10 Jan 2010 17:55 Worked Like a champ!!! Thankyou very much!!! I wish I had came here 2 hours ago!!! "Eduardo" wrote: > 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 > > "Stehy" wrote: > > > 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 !  |  Pages: 1 Prev: Match values in more than one columnNext: Thanks