Hi all,
I am pretty new to spreadsheets and am trying to keep a running total as I pay down a debt. I have the total in one cell (let’s say C4) and then below I have each month in column B (e.g. B5 Dec 2020, B6 Jan 2021, B7 Feb 2021 etc) and in the C column, I want to put the amounts I pay off (e.g. C5 $300, C6 $800, C7 $500 etc.). I am writing the formula in C30 (at the end of the list of months when I intend to have the debt paid off) and am trying =C4-C5:C29. I have tried doing it with one repayment in C5 and C6 through C29 blank. I then tried putting $0 in C6-C29 thinking maybe it needs at least some figure in there to calculate properly. But no go - I get a #VALUE! error message.
Help! It would give me great satisfaction to learn how to do this! (rather than having to manually calculate each month!)
Hello,
Try: =C4-SUM(C5:C29)
Absolute legend! Thank you!
Then please mark the answer as correct by clicking the check mark icon. Thanks.