You could also place a subtotal function using the count option two cells
below the range, then place a filter on the range. This way, you can quickly
get the count of 3's, then 5's, 7's, etc., without having to re-write the
countif function constantly.

First, in cell A1002 -
=subtotal(2,a1:a1000)

Then, highlight A1:A1000 and select Data/Filter/AutoFilter.

Use the filter box to select the value that you want to count and the
subtotal function will automatically count it.

"Alex C" wrote:

I need to know how to count the number of times a specific number appears
within a range. ie. cell A:1 thru A:1000 - how many times was the number 3
entered. Disregard all other numbers that may of been entered.