Formula for Dynamic Rolling Sum

I have been trying to determine the best way to do this for weeks. Any help would be much appreciated!

The attached spreadsheet calculates both expected and actual ROI for a single project. From that, I need to calculate a 12 month rolling ROI from today's date. To make it slightly more complicated, we only capture ROI for a set amount of time so there will be instances in which, for example it is November '16 so I'm trying to calculate Dec '15 to Nov '16, however, some projects will only have values from Dec '15 to Jun '16.

ALSO, there are values generated for the future that should not be counted into the rolling 12 months until we are actually in the corresponding month.

Excel gurus please help!

Please add some typical results so that we can see the end goal. For instance it's not clear to me whether you ignore months where there is NOT a realised saving. e.g. Project 8, March & July -September 2016

Hi,

In D3 enter

Formula:

Please Login or Register  to view this content.

and copy across

In T4 Enter

Formula:

Please Login or Register  to view this content.

and in U4

Formula:

Please Login or Register  to view this content.

and copy down

Incidentally I'd urge you not to use merged cells. One day they will trip you up. Most of us avoid them like the plague for reasons that needn't concern us just at the moment.