View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
WiFiMike2006 WiFiMike2006 is offline
external usenet poster
 
Posts: 23
Default Summing a range based on value criteria

Hello. I am trying to find a way to only sum the numbers in a range of data
that are positive in one cell, and negative values in another cell. Can
anyone please tell me what formula to use to analyze the values in the range
of data to pick out only the cells with either a <0 or 0 value and to sum
only those values?

Thank you very much. This one is making my head feel like it's going to
explode.

Mike