Counting Words

Posted by David on December 07, 2001 6:29 AM

I am wondering if there is any way, probably using a formula, of counting how many of a certain word there are in a coloumn. It would have to differentiate between words.
Thank You.
David.

Posted by Mark W. on December 07, 2001 6:47 AM

=COUNTIF(A1:A5,"* word *")+COUNTIF(A1:A5,"word *")+COUNTIF(A1:A5,"* word")
will count how many times the word, "word", appears.

For the list (entered into cells A1:A5)...

{"words";"new word";"Word document";"The word of the day";"wordy"}

... the result is 3.

Posted by David on December 11, 2001 3:10 AM

Thanks very much.