Forum Discussion
EXCEL
Hi, I want to use this code.. =IF(C2="","",SUM($C$2:C2)) but how do I change it so it is the sum of two columns added instead of one?
If so, I suggest to use this formula instead:
=IF(AND(C2="",D2=""),"",SUM($C$2:D2))
Place it in cell E2, and copy it down.
I hope this helps you
Regards
I would still like to see the Total at E2 and E4. It would only show the total when i enter column C not column D.
If so, I suggest to use this formula instead:
=IF(AND(C2="",D2=""),"",SUM($C$2:D2))
Place it in cell E2, and copy it down.
I hope this helps you
Regards
If i would like Column D as a deduction what formula will I be using?
Sorry for so many questions...
No problem.
Please try this formula to deduct the values in column D.
=IF(AND(C2="",D2=""),"",SUM($C$2:C2)-SUM($D$2:D2))
Regards