From the archive
Day 7
Monday, 10 August 2026
Intermediate
Total closed deals by region with SUMIFS
One number the sales manager actually asked for, buried in a log that answers a different question by default.
Task:
The regional manager wants to know how the West region's closed deals are doing. From the deal log, work out the total value of closed deals in the West region in B8, how many closed West deals there were in B9, and the average size of those deals in B10.
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.
- 29Day 29 · Tuesday, 1 September 2026Turn three weighted criteria into one vendor scoreLatest
- Day 28 · Monday, 31 August 2026Work out take-home pay without repeating the gross pay three times
- Day 27 · Sunday, 30 August 2026Work out how many cartons an order needs, and what's left in the last one
- Day 26 · Saturday, 29 August 2026Average response time for one priority, one team
- Day 25 · Friday, 28 August 2026Set contract review deadlines from a rush flag
- Day 24 · Thursday, 27 August 2026Back into the interest rate a financing offer never quotes
- Day 23 · Wednesday, 26 August 2026Look up carrier rates without an error for the one that isn't contracted
- Day 22 · Tuesday, 25 August 2026Split an order number into its channel and sequence
- Day 21 · Monday, 24 August 2026Total a purchase order without a helper column
- Day 20 · Sunday, 23 August 2026Pull the items that need reordering off a warehouse count
- Day 19 · Saturday, 22 August 2026Rank a sales contest without reordering the table
- Day 18 · Friday, 21 August 2026Decide which support tickets get escalated
- Day 17 · Thursday, 20 August 2026Work out shipping cost from a weight bracket table
- Day 16 · Wednesday, 19 August 2026Check whether a retirement savings plan hits its target