Expert: Craig - 10/8/2008

Question
Sorry for the basic question, but I am really new to excel.  I need to count the number of times a number appears in a column(i.e, my column 'D'..the #4 appears x number of times, the #5 appears x number of times, etc).  Column 'D' is assorted in ascending order.  How do I use the count function to count the number of times each number appears?  Thanks.

Answer
Hi Fred,

You actually don't need to have column 'D' sorted in any order.  Assuming your column is 500 numbers long, D1 to D500:

You'll actually want to use the COUNTIF function.

For each of your numbers, you'll set up a formula like this:

=COUNTIF($D$1:$D$500,4)

Where D1 to D500 is your range and 4 is the criteria to match.



Hope this helps,

-Craig