add numbers if they meet criteria...?
Try something like this:
Sum of the numbers less than or equal to 50
=SUMIF(A1:A100,"<=50",A1:A100)
Sum of the numbers greater than 50
=SUMIF(A1:A100,"50",A1:A100)
Does that help?
***********
Regards,
Ron
XL2002, WinXP
"Dan B" wrote:
Hi,
I have a column of numbers. I need a formula that will look at the whole
range and add up only the numbers that are 50 or less. Then I need another
formula that will add them if they are 51 or more.
Thanks for the help.
|