Sum and Skip Negative Numbers

[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!!!

 

[Ron Coderre]

Try something like this:

=SUMIF(A1:C1,">=0",A1:C1)

Does that help?

Ron

 

[AlDeb]

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

 

[Domenic]

Try...

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

Hope this helps!

 

[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