Lets say I have two bank books. I put my starting balance on Sheet1 in cell D3 $5,000.00 – for my first bank book. I put my starting balnce on Sheet2 in cell D3 $10,000.00 – for my second bank book. I want a running total of the two bank books on Sheet2 in cell E4. So I need a formula in cell E4 on Sheet2 that gives me $15,000.00.
Now here is my problem. I will be taking money out of both bank books. So lets say I take out 200 on Sheet1. I would put that number in cell C4 and my new balance would show up in D4 as $4,800.00. I now need in Sheet2 cell E3 to show $14,800.00.
Now lets say I take out more money from bank book one or Sheet1. I take out 300 and then 400. So I will put 300 in C5 and 400 in C6 and my new blance in D6 in now $4,100.00 in Sheet1.
I also take money from bank book two or Sheet2. I take out 1000. So I will put $1000.00 in cell C4 and my new balance would show up in D4 as $9,000.00. Now I need my formula in cell in cell E3 on Sheet2 that gives me $13,100.00.
So I need a formula in Sheet2, cell E3, which will continue to give me the results I
