[...trimmed text...]

Scott,

=SUM(IF(B4<0,0,B4)+IF(B8<0,0,B8))*2

The formula I gave you checks both B4 and B8, if either value is less than zero it replaces the negative number(s) with a zero.

If you only want it to ... Login to read more.