Day 88 · Friday, 30 October 2026
An average of days late that counts the on-time shipments as zeros answers the wrong question. Adding a ">0" condition to AVERAGEIFS sets the on-time ones aside, so the figure says how late a carrier runs when it is late at all.
You manage outbound logistics for a furniture distributor and are getting ready for the quarterly carrier review. Column C records how many days late each shipment arrived, with 0 meaning on time. For each carrier listed in E2:E4, use COUNTIFS in column F to count its late shipments (more than 0 days late), and AVERAGEIFS in column G to find its average days late, counting only the shipments that were actually late. Fill in rows 2 through 4.
A new exercise every morning, plus every day that came before it — a back catalogue that grows by one a day, whether or not you were here for it.
The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.