From the archive
Saturday, 29 August 2026
COUNTIFS and AVERAGEIFS both take range/criteria pairs — stack two and only rows matching all of them count.
You run the IT help desk queue for a mid-size company. This week's tickets are logged with their priority, the team that handled them, and how many hours each took to resolve. Leadership wants to know how the Network team is doing specifically on High-priority work: how many such tickets came through, and how long they took to resolve on average. Put the count in D10 and the average resolution time, in hours, in D11.
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.