Count numbers

  • Thread starter Thread starter T3
  • Start date Start date
Try this:

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

Hope this helps.

Pete
 
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.
 
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
 
.... or even


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


<bg>
 
LOL

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

Cheers
Martin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linear Regresion. Sales By Year. 1
Finding the median of numbers meeting criteria 3
formula help... lookup or ref? 1
counting cells 2
VLOOKUP 3
Top value 8
VLOOKUP / Auto Fill / IF? 4
Finding 'optimum' values in a range 5

Back
Top