Adding Positive or Negative Values
To add up the positive values in a column you can use
=SUMIF(A:A,">0")
This will display the total of all the positive values in column A.
To add up the negatives use
=SUMIF(A:A,”<0″)
This will display the total of all the negative values in column A.
Please note: I reserve the right to delete comments that are offensive or off-topic.