Count numbers
 

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

Count numbers
 

Try this:

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

Hope this helps.

Pete

On Aug 26, 9:27*am, T3 wrote:
*say 1400 & <1500 in a range from 1200 to 1600

Count numbers
 

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

Count numbers
 

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

Count numbers
 

.... 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

Count numbers
 

Thanks all,
Worked perfectly.

T3

"T3" wrote:

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

Count numbers
 

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