Sum and Skip Negative Numbers

A

AlDeb

I have three columns of numbers. I want to sum the three columns into a
fourth column. NO problem there! My issue is if one of the columns has
a negative number I do not want to sum the negative number. How can I
write that into a formula?

Please help!!!
 
A

AlDeb

What do I do if the three columns I am summing are F4, I4, & L4??? The
three columns are not all together.
 
D

Domenic

Try...

=SUMPRODUCT(--(MOD(COLUMN(F4:L4)-COLUMN(F4),3)=0),--(F4:L4>0),F4:L4)

Hope this helps!
 
R

Ron Coderre

As long as you only have a few cells to sum, this will work:

=SUM(MAX(F4,0),MAX(I4,0),MAX(L4,0))

Does that help?

Ron
 
Top