Summing Only Negative/Positive Values

In this tutorial you will teach yourself how to sum only positive or only negative numbers from your range.

Suppose that you have some values in A column. Your task is to sum positive only or negative only values. To do that just use one of these formulas:

  • For positives: =SUMIF($A:$A,”>0″)
  • For negatives: =SUMIF($A:$A,”<0″)

positives negatives sum

Isn’t it easy? Excel works great when you can create such formulas. In case you needed to sum positive integers or only negative values you may use above formula.


You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial