=countif(a1:a10,""&1000) - countif(a1:a10,""&2000)

is one way. (I'm not sure what should happen at 1000 and 2000, though. You may
want to change the to = in either or both (or none).)

Jason30 wrote:

How do I count the number of cells that have values between for example $1000
and $2000?

--

Dave Peterson