I have 4 columns : A1 is date; B1 is Advance; C1 is Deposit and D1 is
Total...
How do I do this formula so that D1 shows the total. The total column will
be in a negative because the Advances are more than the Deposits but I think
if I just insert the Advance with a - sign, this should work. Have spent an
hour trying to figure out this simple thing, so finally decided to ask for
help.
Thanks!