Adding Negative and Positive Numbers
Try these:
Negative numbers:
=SUMIF(A1:H1,"<0")
Positive numbers:
=SUMIF(A1:H1,"0")
--
Biff
Microsoft Excel MVP
"Jacq" wrote in message
...
Quick question:
If I have the following numbers in a row:
5, 15, 10, -15, -22, 4, 10, -15
Is there a formula I can use for excel to only add up the negative numbers
and ignore the positives?
And is there a formula I can use to only add up the positve numbers and
ignore the negatives?
Thanks
|