add numbers if they meet criteria...?

D

Dan B

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

Ron Coderre

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
 
D

Dan B

Yep, it helps a ton. Thank You!

Ron Coderre said:
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
Click to expand...
 
Top