View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacq Jacq is offline
external usenet poster
 
Posts: 8
Default Adding Negative and Positive Numbers

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