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))




Reply With Quote
Bookmarks