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

  • Thread starter Thread starter woodac
  • Start date Start date
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?
 
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
 
=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum every Nth Row (almost working) 1
Sum function 3
Why do I get correct answers to formula then #NAME for some no's 1
If sign of sum is negative change to positive 1
Need Help with "SUM" AND "ABS" in same formula 12
Sum Values from different column 1
autosum refusal to sum highlighted range 4
How can I copy the sum of a filtered column into a cell in anothe 1

Back
Top