If a cell could have more than 1 occurrence of 3, and you want to count all,
then use

=SUMPRODUCT(--(LEN(A1:A1000)-LEN(SUBSTITUTE(A1:A1000,"3",""))))

--
HTH

Bob Phillips

"Alex C" <Alex wrote in message
...
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.