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.

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.

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.

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