Formula in Excel to show greater than 50, but less than 250?
 

I have a list of numbers ranging from 2 to 5,000. I need a count of how many
are greater than 50, but less than 250. I would also need a sum once that is
figured out. I've tried everything. This is Excel in Windows XP.

Formula in Excel to show greater than 50, but less than 250?
 

Janice --

One of the MVP's will come along with a more elegant solution, but this'll
work too:

A B
1 1 =AND(A150,A1<250)
2 51 copy
3 76 down
4 285
..
..
..
=COUNTIF(B1:B4,"TRUE")
=SUMIF(B1:B4,"TRUE",A1:A4)

HTH in a pinch.


"Janice B. - Cleveland, Ohio" wrote:

I have a list of numbers ranging from 2 to 5,000. I need a count of how many
are greater than 50, but less than 250. I would also need a sum once that is
figured out. I've tried everything. This is Excel in Windows XP.

Formula in Excel to show greater than 50, but less than 250?
 

THANKS!!!! You're a PEACH!!!!!

"Janice B. - Cleveland, Ohio" wrote:

I have a list of numbers ranging from 2 to 5,000. I need a count of how many
are greater than 50, but less than 250. I would also need a sum once that is
figured out. I've tried everything. This is Excel in Windows XP.

Formula in Excel to show greater than 50, but less than 250?
 

if you wish to stick with sumif and countif also check if the and <
should be = or <= for your logic

=sumif(a1:A100,"50")-sumif(a1:a100,"250")
=countif(a1:A100,"50")-countif(a1:a100,"250")

or use sumproduct((a1:A10050)*(a1:a100<250)) for the count

or use sumproduct((a1:A10050)*(a1:a100<250)*(a1:a100)) for the sum

regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=560027