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.