formula for sum of positive numbers only

Question

Level 1

10 points

I have a column to add the above numbers, but want it to add all the positive numbers and disregard all the negative numbers. Is it possible and how?

Posted on May 2, 2018 7:57 PM

Reply

Answer 1

Top-ranking reply

Level 7

21,987 points

Or, =SUMIF(B,">0")

If sum-values is omitted, the default value is test-values.

Regards,

Ian.

Reply

Answer 2

Level 7

21,987 points

Hi Brian,

SUMIF is your friend.

The table has a Header Row and a Footer Row to confine the formula references to only the Body Cells.

=SUMIF(B,">0",B)

SUMIF(test-values, condition, sum-values)

Regards,

Ian.

Reply

Answer 3

Level 1

10 points

seems to do the trick. thanks

Reply

Similar questions