SUM positives

SUM positives or negatives only

By Neale Blackwood, 30 Apr 15

If you need to SUM only the positive numbers in a range then use the SUMIF function. If the range is A1:A1000 then the following formula will SUM only the positive numbers.

=SUMIF(A1:A1000,”>0″)

This following formula will SUM all the negative amounts

=SUMIF(A1:A1000,”<0″)

The third part of a SUMIF function is optional and can be omitted if the range you want to SUM is the same as the Criteria range, as in the two examples above.