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?
