How do I do that?

First time here? Check out the FAQ!

x

+1 vote

Counting in Excel is done using COUNTIF formula. If you want to count the repeating words in a CELL range please use this formula:

**=COUNTIF(A1:A2000,"WORD")**

Type this formula in cell A2001 and replace WORD with the one you want to count for.

...