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.