Formula To Sum From Movement To Cummulative Total

[excel_learner]

Thanks, i would say it will be either blank or 0 (as it comes from another formula) saying that there was no movement in that year, but it in cumulative table should add up with last year i.e the cumulative total should remain same as last year for the year where no movement is reported. The example i have attached in "Output required" this is what is required.

see if this helps.

[p45cal]

Thanks, i would say it will be either blank or 0 (as it comes from another formula) saying that there was no movement in that year,

in which case what you ask is impossible as there is no way to differentiate between a blank or zero being a 0 being after a final year or a blank or zero being a zero value year with more years to come perhaps

but it in cumulative table should add up with last year i.e the cumulative total should remain same as last year for the year where no movement is reported. The example i have attached in "Output required" this is what is required.

This had already been established and is no further help.