No, Amy, it is counting the numbers *greater than* 4999 (not less than), and
subtracting those greater than 9999. The result is those which are greater
than 4999 and less than or equal to than 9999.
As you wanted greater than 4999 and *less than* 9999, then in Roger's
formula I would change ,"9999" to ,"=9999"
--
David Biddulph

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