From the archive

Day 26

Saturday, 29 August 2026

Intermediate

Average response time for one priority, one team

COUNTIFS and AVERAGEIFS both take range/criteria pairs — stack two and only rows matching all of them count.

Task:

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.

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.

Recent days

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