Auto Sum ??

  • Thread starter Thread starter Aud
  • Start date Start date
A

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
 
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
Click to expand...
 
Back
Top