From the archive

Day 8

Tuesday, 11 August 2026

Day 7Day 9
Intermediate

Count tickets on more than one condition at once

COUNTIF answers one question about one column. A real queue asks about two or three columns together.

Task:

You run the support queue for a small SaaS product. Nine tickets came in today, each logged with its agent, priority and current status. In B11 count how many High-priority tickets are still open across the whole queue. In B12 count how many High-priority tickets Jordan personally has already resolved.

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.

See what Pro includesBack to the latest

Recent days

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