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.
@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: