I have different words in a cell range C1:C400 and I want to find how many times each word occurred in a database of repeating words in cell range A1:A2000

Question

2 Answers

Pete Clapp · Answer 1 · 2013-03-12T08:04:37+0000

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.

Answer 2 · 2013-03-12T11:03:16+0000

Use the following formula in the cell A2001:

=COUNTIF(A1:A2000,"XX")

Replace XX with the word you want the count for.