Help with a numbers sumif or sumifs formula

Refer to this Numbers Formula Overview. Scroll down to 'Numeric'>Sumif

http://help.apple.com/functions/mac/7.3/#/ffaef5aeec8

Hi Gerald,

SUMIF and SUMIFS are not appropriate to this task. The IF(S) in those function names refer to conditions determining whether an amount will be included in the sum or not, not to what to do if the result is a particular value or in a particular range.

The IF that you could use here is IF itself.

IF(SUM(B2:C2)<0,0,SUM(B2:C2)

In words: If the sum of the value in B2 and C2 is less than zero, the result is 0, otherwise, the result is the sum of the values in B2 and C2.

SG's MAX(0,SUM(B2:C2) gives the same result using a different logic and a simpler formula.

In words, it says: Take the greatest value from these choices: 0, SUM(B2:C2)

Regards,

Barry

If the first cell is B2 and second cell is C2, then you could do something like this:

=MAX(0,B2+C2)

SG