Dec 04 2021 01:29 PM
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.
Dec 04 2021 03:16 PM
@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")