Hi T3,

I'm sure it was just a typo, Pete meant
=COUNTIF(range,"1400") - COUNTIF(range,"1500")

Depending on your requirements you may also need
=COUNTIF(range,"=1400") - COUNTIF(range,"=1500")
or some other slight variant

HTH
Martin

"T3" wrote in message
...
Cheers Pete
But this counts all numbers above 1400 and then all numbers below 1500 and
the difference could be a negative value, its the number of numbers
between
the two values.



"T3" wrote:

say 1400 & <1500 in a range from 1200 to 1600