Formula To Sum From Movement To Cummulative Total

I want the movement figures in one table to sum at cummulative level and stop if all values are summed up at last year, i have attached an example to formula and output required.

Kindly assist.

Spreadsheet Formulas:
Cell Formula
C15 =IF(C4=0,0,SUM($C4:C4))
K15 =SUM(C4:J4)


C15 filled across to J15, then filled down
K15 filled down

?

Thanks much.

Dear I have observed a small issue with the formula that, if in movement any year value is 0 then it does not accumulate for upto that year. I have attached an example highlighting the same.

Kindly see.

Your example file, in cell E4, rather than showing a 0 (zero), is actually blank/empty. Curiously, cells I4 anf J4 contain 0s (zeroes) although you have those zeroes appearing as dashes.
The difficulty lies when we encounter a cell such as G6; Is this cell showing 0 for 2013 because that year had no movement, or is there simply no value for that year? Your answer determines whether there should be a value appearing in G17 or not of your most recent file.
Personally, I think it confusing that there should be 0 values in a cell such as I7, and years with no movement are plain blank (D7).

Reply with how you really want the values in those cells to be and I will provide a formula.

There is a much more complicated formula that I could give but I don't think you or I want to go down that route.

If you reply as I expect, then the formula will be:
=IF(ISBLANK(C4),"",SUM($C4:C4))

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.

Quote:

---

Originally Posted by 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,

---

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

Quote:

---

Originally Posted by excel_learner

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.