Adding Negative and Positive Numbers

  • Thread starter Thread starter Jacq
  • Start date Start date
J

Jacq

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
 
Try these:

Negative numbers:

=SUMIF(A1:H1,"<0")

Positive numbers:

=SUMIF(A1:H1,">0")
 
=SUM(IF((A1:H1)>0,A1:H1)) for positives
=SUM(IF((A1:H1)<0,A1:H1)) for negatives

These are array formulas entered with CNTRL-SHFT-ENTER rather than just ENTER
 
Back
Top