Adding negative and positive numbers separately

[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

 

[Greg Collins]

Your question is best asked in the Excel newsgroup.