Excel 2008 : A formula that carries over into other cells in the same row

Hello, I am not sure how to ask what I want. I am pretty sure I remember being able to do it in highschool, but anyway, here is an example of what I want to do.

In my spreadsheet I have TOTAL OWED typed in cell b1 with the actual figure in b2. What I want is for the total in b2 to subtract the amount (payment) I put into cell b3, then next month subtract the amount (payment) I put into cell b4 and so on.......changing the total in b2 every time I make a payment in the next column.....without having to reconstruct the formula every month so that it subtracts from the new entry.

I hope this is clear.

Thank you in advance


Caleb

teylyn,

Thank you sooo much. I new it was something relatively simple but could not remember it. Its been bothering me for the last few hours. I applied the first formula and it works. Thank you again

caleb