Try...

=COUNTIF(A1:A1000,3)

Hope this helps!

In article ,
Alex C <Alex 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.