LOL

I'd like to claim typo too, but probably more likely the beer. <g

Cheers
Martin


"Bob Phillips" wrote in message
...
... or even


=COUNTIF(range,"1400") - COUNTIF(range,"=1500")


<bg

--
__________________________________
HTH

Bob

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