I have a workbook that tracks data by individual days. So i have a sheet for every weekday of the month. 1-6-20, 1-7-20, 1-8-20, 1-9-20, 1-10-20, etc... Each sheet tracks "loads" for a warehousing company tracking the booking number(A), carrier(B), trailer #(C), check in time(D), appt time(E),Load Type (Live, Drop, Pre-Load) (F) Warehouse personnel that worked on it(G), warehouse personnel start time(H), warehouse personnel end time(H), total work time (L), and to time from check in (D) to to warehouse personnel end time (H) resulting in (M) (=sum(H)-(D)) =(M)).
i basically need the following formula to work across multiple sheets.
=AVERAGEIF(F12:F500, "Live", L12:L500)
I also use the following formula in google sheets to calculate the average on one particular sheet based on multiple criteria, but i cannot get it to work on excel.
=ArrayFormula(AVERAGE(IF(F4:F200={"Live","Drop/Live", "Inbound/Live"}, M4:M200)))
Thank You in advance.
Bookmarks