Counting cells between ranges

J

Jason30

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

Max

Jason30 said:
How do I count the number of cells
that have values between for example $1000 and $2000?
Click to expand...

One way is to use 2 countifs ..
Assuming source data in col A, placed in say, B1:
=COUNTIF(A:A,">=1000")-COUNTIF(A:A,">2000")
 
F

Franz Verga

Jason30 said:
How do I count the number of cells that have values between for
example $1000 and $2000?
Click to expand...

If your range is A1:A100, you could use this formula:

=COUNTIF(A1:A100,"<="&2000)-COUNTIF(A1:A100,"<"&1000)


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
P

Peo Sjoblom

=COUNTIF(A1:A100,">=1000")-COUNTIF(A1:A100,">2000")

or

=SUMPRODUCT(--(A1:A100>=1000),--(A1:A100<=2000))


both formulas include 1000 and 2000, if you really want between use ">1000"
and ">=2000"
in the first and >1000 and <2000 for the last


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
 
D

Dave Peterson

=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).)
 
Top