Count how many times something occurs

Tim in Toronto

New Member
Joined
Nov 18, 2004
Messages
47
Hi All, me again.... Is there a quick formula that can tell me how many times something occurs in a column. For example, if I have a 100 row sheet, and in column A there are only say, 8 different words, but they occur many times each to total 100 rows of info. How can I count how many times each word appears in that column.

Timbit :)
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Scott Huish

MrExcel MVP
Joined
Mar 17, 2004
Messages
19,958
Office Version
  1. 365
  2. 2010
Platform
  1. Windows
Not sure I follow, is each word the only value in the cell or is other text with it? Is the word in the cell more than once?

If it's just one word per cell, try this, replace word with the word you want to count:

=COUNTIF($A$1:$A$100,"word")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,377
Messages
5,571,775
Members
412,419
Latest member
acemali
Top