You can make a difference in the Apple Support Community!
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.
I have a column full of numbers some of them are positive and others are negative. I would like to ignore the positive numbers and just add up the negatives. Is this possible, and if so, how would I accomplish it?
Thanks!
Hi marshallhiens,
SUMIF() should do it for you.
SUMIF(A,"<0",A)
will sum all the values in A that are less than 0.
quinn
Hi marshallhiens,
SUMIF() should do it for you.
SUMIF(A,"<0",A)
will sum all the values in A that are less than 0.
quinn
So killer. Thanks!
glad to help.
q
Is it possible to selectively sum numbers in a column?
