Counting words............

B

BenjieLop

Smokey_Vol said:
How can I give the total of how many times a word appears in a column?
Click to expand...

Assuming your column range is A1:A100, you can use this

=COUNTIF(A1:A100,\"WORD_THAT_NEEDS_TO_BE_COUNTED\")[/B] OR

IF THE WORD THAT YOU WANT TO COUNT IS, SAY, IN CELL B1, THE ABOVE
FORMULA CAN BE MODIFIED TO BE

=COUNTIF(A1:A100,\"*\"&B1&\"*\")

Hope this is what you looking for.

Regards.
 

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

How to count the numbers in a Word document? 0
Word VBA - Want to test if Full Name is NOT Present in document 0
Incone & Expenses Statement 0
Insert name and adress from a list in a word document 1
How can the font and size of (all) citation numbers be altered? 1
Remove Identical words 0
Setting up a chapter a word-count inventory for a novel 1
Excel --> Word 4

Top