what formula to get total from two different columns
 

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?????

what formula to get total from two different columns
 

Post your formula.
--
Brevity is the soul of wit.


"Mikeymike" wrote:

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?????

what formula to get total from two different columns
 

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



Mikeymike wrote:
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?????