Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|