Day 88 · Friday, 30 October 2026

From the archive

Intermediate

Score Carriers on Late Deliveries with COUNTIFS and AVERAGEIFS

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.

Task:

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.

The daily challenge is part of Pro

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

The last 14 days. Today's challenge is free while your streak is alive; Pro opens every past day too.