=sumif(a1:a10,""&0)
=sumif(a1:a10,"<"&0)



WiFiMike2006 wrote:

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

--

Dave Peterson