<0 formula help

[ryan7]

my formula is =IF(L7<1000,L7+M7+N7+O7,M7+N7+O7)

I want to build into it that if one of the cells is less than 0 (Has a a negative value), then it does not add it up.
I know I should be using MAX 0 but can't seem to build in properly.

Thanks

 

[Legacy 143009]

This is what you are looking for:

=IF(L7<1000,SUMIF(L7:O7,">0"),SUMIF(M7:O7,">0"))

 

[hrayani]

Hello,

Is this what you want

=IF(L7<1000,SUMIF(L7:O7,">0"),SUMIF(M7:O7,">0"))

 

[ryan7]

This is what you are looking for:

=IF(L7<1000,SUMIF(L7:O7,">0"),SUMIF(M7:O7,">0"))

Worked