If you wanted to search through Column A, try this:

=COUNTIF(A:A,25)

If 25 was the number you were looking to count.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Greg B" wrote in message
...
what function do I used to have excel search through columns and show how
many times the number I want appears?