Sum and Skip Negative Numbers
 

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


--
AlDeb
------------------------------------------------------------------------
AlDeb's Profile: http://www.excelforum.com/member.php...o&userid=25391
View this thread: http://www.excelforum.com/showthread...hreadid=388652

Try something like this:

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

Does that help?

Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=388652

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


--
AlDeb
------------------------------------------------------------------------
AlDeb's Profile: http://www.excelforum.com/member.php...o&userid=25391
View this thread: http://www.excelforum.com/showthread...hreadid=388652

Try...

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

Hope this helps!

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


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=388652

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


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=388652