Day 105 · Monday, 16 November 2026

From the archive

Intermediate

Count Parcels by Delivery Band with FREQUENCY

A courier review asks how many parcels arrived inside each promise, not the average delivery time. FREQUENCY counts a whole column into bands in one formula, reading each limit as "up to and including", and spills one extra row for everything past the last limit, which is exactly where the late parcels end up.

Task:

You look after fulfilment for an online homeware shop, and the courier's contract is up for renewal. Ten parcels from last week, with the hours each took from dispatch to the customer's door, are in A2:B11. The courier promises next-day delivery as up to 24 hours, two-day as up to 48 and three-day as up to 72; anything slower counts as late. The band limits are in E2:E4. In F2, enter one formula that fills F2:F5 with the number of parcels in each band: next day, two days, three days and late.

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.