Day 100 · Wednesday, 11 November 2026

From the archive

Intermediate

Report Support Reply Times with MEDIAN and a COUNTIF Hit Rate

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.

Task:

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.

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.