Omitting Negative Numbers

[Caplin Girl]

Hi there,
I'm wondering if there is a formula that will omit a number from a table
when it is negative. If so, please inform me how to add it to a formula that
looks like this:
=SUM(B90,B109,B149,B168)-B128-B187
Thanks.

 

[Gary''s Student]

=MAX(B90,0)+MAX(B109,0)+MAX(B149,0)+MAX(B168,0)-MAX(B128,0)-MAX(B187,0)

 

[Caplin Girl]

sorry, this didn't work. i put your formula
=MAX(B90,0)+MAX(B109,0)+MAX(B149,0)+MAX(B168,0)-MAX(B128,0)-MAX(B187,0) in,
but the result is still -2. I need that cell to read 0 to make the table
useful.

have i done something wrong?
i have very little experience working with excel, so maybe you left
something out that would seem obvious to you?

 

[Gary''s Student]

The formula treats all the B's as zero if they are negative, but if B128 or
B187 is/are really big, the final result can still be negative.

 

[Caplin Girl]

I just found a different post that suggested this which worked perfectly.
=MAX(0,SUM(B90,B109,B149,B168)-B128-B187)
Thanks for your assistance today!