Adding three columns together

[rabster64]

Howdy,

As the title states I am a little bit of an excel noob, at least with anything more than adding and subtracting data.

I think it is easier if I just explain in words what I am trying to do.

Okay so I have three columns:

Column 1 Column 2 Column 3

100 50 50
150 50 100
100 20 80




At the moment column 1 subtracts from column 2 and the answer is in column 3.

The way I did this is =a=*1-*2 formula for every cell in column 3.


Great it works.


However what i would like to do is that whatever the answer is in column 3 to be added to the next number in column 1. it is for a day by day budget. below is the same numbers with different headings:


Allowance Spent Remaining Balance

Day 1 100 50 50
Day 2 150 50 100
Day 3 100 20 80



So I want the answer in (remaining balance column) to add to the next day's (allowance column)

So essentially the table would now look like:

Allowance Spent Remaining Balance

Day 1 100 50 50
Day 2 200 50 150
Day 3 250 20 230


Can anyone help with the formula to make this happen with maybe a little instruction to help an out.

You will be spreading the karma to a good person

:-)


Thanks in advance