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.