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.

Related Posts

Please note: I reserve the right to delete comments that are offensive or off-topic.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.