Summing Only Negative/Positive Values

Summing Only Negative/Positive Values

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″)

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.

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References