running numerical value based on rolling previous 12 months

Occasional Visitor

I have an excel file of flight time entered by date and aircraft type. I need a cell that shows the rolling total time for the previous 12 months for two different aircraft. not sure how to add in the time requirement. 

1 Reply

@agfueler  Similar to how you did total times for each plane type using SUMIF, you just change to SUMIFS and add an additional condition for within 1 year.  For simplicity I did 365 days but if you have to do exactly 1 year it could be tweaked:

=SUMIFS(Logbook!$J$5:$J$7301,Logbook!A5:A7301,">"&TODAY()-365,Logbook!$B$5:$B$7301,"B707")