add numbers if they meet criteria...?
 

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.

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.

add numbers if they meet criteria...?
 

Yep, it helps a ton. Thank You!

"Ron Coderre" wrote in message
...
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.