Rolling averages and sums for the year

I'm working with the state department of air quality trying to track information on my generators, and now they're asking for rolling 12 month sums for runtime (and a few other things). Since this document is expected to last for years, track 200 generators run monthly, and have thousands of lines;, the equation also has to be simple enough that it doesn't break excel or use up the allocated memory for the program.

I need to create a column with a formula which will look at Generator Name, run time, and date of run. So for any generator named "L100 B" it'll add those runtimes but only for the last twelve months (february 2017 to february 2018, march2018 to march 2019, etc).

My sample excel sheet is 6 lines and 4 columns, with no calculations or conditional formatting, yet it's too big to upload so I've reproduced it below.
The first three columns are my criteria, and the fourth column is what I need my output to be.




Thank you (edited because I forgot to hit preview, I'm sorry for all the dots)

edited again (13:48 EST) with new larger date range.

Welcome to the forum.

Please update your user profile with the version of Excel that you are using.

Instructions telling you how to upload your workbook are at the top of the page.

We don't need the full dataset - read the instructions again. A sub-set of sample desensitised data is all we need.

I looked but didn't understand your data. I think you've made the sample dataset too small now. There needs to be enough to demonstrate what you want and the logic - there is only one row (the last) where anything is different.

Extended the sample data.
I've gotten the sumif command to work in column F, so it does a lifetime total for each generator in column C.

edit1.
Right now, changed sumif to sumifs so I can do multiple criteria.
F4=SUMIFS( D$1:D4, B$1:B4, B4)

Now looking at say column A.
Using: ">="&DATE(2017,1,1), datecolumn, "<="&DATE(2017,12,31) the Running Total will get an increase if the date is within 2017.

How can I change that so that it's say teh date in cell A4 up to a year prior?


edit 2.
My start date (12 months prior) can be formulated as =(edate(a4, -12))-day(a4)+1). If cell a4 is Aug 28 2017, then that command gives Aug 1 2016.
However it's still not working to plug that into sumifs as a start date.