View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Daniel Collison Daniel Collison is offline
external usenet poster
 
Posts: 9
Default summing only positive or negative values

I have a list of values, some of which are positive and some are negative. I
want to sum all positive values in the list, and all negative values in the
list.

Is anyone aware of a function that allows me to do this?

Thanks,