View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
somethinglikeant somethinglikeant is offline
external usenet poster
 
Posts: 94
Default sum positive and negative values separately

All is possible.
Free your mind and your ass will follow


Assuming your original list is in column A and B
paste the following formula into C1 and paste down as far as you need.

http://www.excel-ant.co.uk