Hi Amy

One way, with data in column A, enter in B1
=COUNTIF(A:A,"4999")-COUNTIF(A:A,"9999")

--

Regards
Roger Govier

"Amy" wrote in message
...
I would like to count the number of cells in a range that has a number in
it
that is greather than 4999 but less than 9999 - any ideas