what formula to get total from two different columns

M

Mikeymike

I have a worksheet that i want to use to keep track of my bank account i.e
money in and money out to give me a total in the third column and cannot work
the formula out as 1 column is taking away and the secon column is adding?????
 
V

vezerid

If you want a running total the general philosophy is that in the total
column you need one additional cell.

So if inflows are in A2:A10 and outflows are in B2:B10, put your
starting balance in C1 and then in C2 use:

=C1+A2-B2

Does this help?

Kostis Vezerides
 
Top