Roger,
Thanks for the advice, what that equation is doing is counting the numbers
less than 4999 and subtracting the numbers that are greater than 9999

"Roger Govier" wrote:

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