Day 100 · Wednesday, 11 November 2026
A help desk's weekly report needs two numbers: how long a customer typically waits for a first reply, and how often the team hits its target. One slow ticket drags the average far from typical, so MEDIAN gives the honest middle, and COUNTIF with a criterion built from the target cell counts the tickets answered in time.
You run the weekly report for a small customer-support team. Each ticket from Monday is in A2:C11 with the minutes it waited for its first reply, and the team's target is in F1: every customer should hear back within 60 minutes. In F2, find the typical wait, the middle value of column C. In F3, work out the share of tickets answered within the target, as a fraction of all ten. A reply at exactly 60 minutes counts as on time, and F3 should read the target from F1 so it still works when the target changes.
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.