Multiple nested sum and blanks or zero

[Aquarock]

I am struggling getting my Columns O and P to calculate correctly. In short, I need the "TOTAL" columns (G, K, O, and P) to increase each year from the previous based on what the current is (Column B) and the "Total Projection in Column P to return the highest value essentially. My error is because if certain cells (Columns D, E, H, I, L and M) are blank or zero, the totals keep messing up. What am I missing here? Example attached. Any help is greatly appreciated as always!

[Bernie Deitrick]

Not sure why you have such a complicated formula for your Totals - For example, column F accounts for the values in D and E, so G could just be B+F, like this in G5:

=B5+F5

And the same for all the other totals:
K5: =G5 + J5
O5: =K5 + N5

[Aquarock]

Hi Bernie, the reason is if they are blanks or zeros then your proposal would show the incorrect math. I.e. if the prior year has zero power, then the total of the next year would not be culminative. Does that make sense?

[Bernie Deitrick]

You did not show the values that you actually wanted so I just guessed - if you repost with 'before' and 'desired' tables showing what you want........

[Aquarock]

I've attached a version like you mentioned with the before and desired, but its so hard to include each scenario where if one of the inputs (D, E, H, I, L, and M) are either a blank or a zero that it adds up correctly for that year, and ultimately the end Total Projection. Hopefully the new version helps to try and clarify this some....

[Bernie Deitrick]

In your desired section, you still have your formulas - I would have expected values, so your 'desired' section seems inconsistent. I don't understand why K13 increments from the base 'current power' but O12 does not.

[Aquarock]

I can't get the formulas to all work, but the totals are the values I am trying to arrive at. K13 increments from the current power (B13) because there are no values in D13 and E13. Then because there is a value in M13...the total you see in O12, will key off the prior year total in K13.