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
Hi calebtroedson,
welcome to the forum.
Is cell B2 currently a formula or a typed in value? If you have a typed value, say, 500 in B2, you could use something like
=500-sum(B3:B100)
If B2 is a formula, then do something like
=(<existing formula>)-sum(B3:B100)
hth
teylyn
Microsoft MVP - Excel
At Excelforum, you can say "Thank you!" by clicking theicon below the post.
Avoid pie charts with more than two data points. Why? See here (pdf, 559 kb). The only acceptable pie chart is here.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks