Adding Negative and Positive Numbers

[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

 

[JE McGimpsey]

One way:

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

 

[T. Valko]

Try these:

Negative numbers:

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

Positive numbers:

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

 

[Gary''s Student]

=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

 

[Jacq]

Thank you all, it worked!!!!!!!!!!