Forum Discussion

hmcquiston's avatar
hmcquiston
Copper Contributor
Oct 09, 2024

Depleting Balance - Help

I wonder if anyone with skills above mine can help me, I can't figure out how to implement this so what I'm trying to do is show a depleting balance as project spend is added. So as data is added to column K the total figure in cell K2 depletes to show the budget committed. 

 

I hope this makes sense and someone can help me I've wasted so much time trying different solutions.

 

Thanks 

Hazelle

 

 

 

 

excel
Formulas and Functions

1 Reply

Sort By
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Oct 09, 2024

    hmcquiston 

    Use two cells for this: one for the initial amount, and a second one for the remaining balance.

    For example, enter the initial amount of £45,000 in R2, and the formula =E2-SUM(E4:E100) in K2.

Resources