View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jordanpcpre jordanpcpre is offline
external usenet poster
 
Posts: 22
Default Adding only negative numbers in row

I have a list of numbers in a row that has both positive and negative numbers
throughout the row. Is there a way I can get a sum of only the negative
numbers?

The row is very long so I would rather not add the negatives one by one. Is
there a formula that will seek only the negative numbers and add them all up?

Thanks!