can I get a sum to go to one or the other cell

W

woodac

Is there a way to add 3 columns and have the sum automatically go into one
column if it is negative and another if it is positive?
 
M

Mike H

lets say you are summing columns A, B & C put this in D1
=IF(SUM(A1:C1)>0,SUM(A1:C1),"")
Only positive values will display
Put this in e1
=IF(SUM(A1:C1)<0,SUM(A1:C1),"")
and it will only display negative values
Drag down as required

Mike
 
G

Gord Dibben

=IF(SUM(A:C)>0,"",SUM(A:C)) in D1

=IF(SUM(A:C)<0,"",SUM(A:C)) in E1


Gord Dibben MS Excel MVP
 
Top