Auto Sum ??

[Aud]

I am new to Excel... I have a column of numbers to add up… such as: 16
22
-10
24
My question is how do I get (auto sum or a formula) to add the number
but to disregard the negative numbers?? I hope that makes sense… thank
for the help!
Au

 

[Debra Dalgleish]

You can use SUMIF: =SUMIF(A2:A5,">0")

I am new to Excel... I have a column of numbers to add up… such as: 16
22
-10
24
My question is how do I get (auto sum or a formula) to add the numbers
but to disregard the negative numbers?? I hope that makes sense… thanks
for the help!
Aud

 

[Aud]

Thank you!!!
Au