Summing only the positive or negative values in the same range of values only sounds difficult. Fortunately, the SUMIF() function can handle both.

How to Get Chart Bars to Show Red When the Value Is Less Than Zero in Excel?. When you create a chart in Excel using positive and negative values, both positive and negative graphs are the same ...