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