Static table is setup in column A and B. Column A contains Products Origin and column B contains Start Time. Dropdown option in E2. When a region is selected in E2, would like AVERAGEIFS to calculate average time based on Produce Time in C2:C20, Start Time in B2:B20, and time interval range in E5 to E14. Desired result should be in F5:F14.
Sample file attached.
Bookmarks