Hi!
Please see the attached spreadsheet.
But basically I have 12 months, and have 6000 to spread across those 12 months, as a sort of forecast.
But then I want to put in actuals each month as static values. I then want any remaining future months to calculate the spread of that 6000 but taking into account the actuals I've put in.
So in my example I put in 600 for Jan, and 100 for Feb. So then each remaining month should be calculated as 530.
Any help for a formula on this?
Thanks!
(I guess I'm asking: is there a way to do it without a helper row)?
Bookmarks