Day 78 · Tuesday, 20 October 2026
SUMIFS matches rows on a criterion without needing the data sorted or grouped first, so every order from the same region can show the same regional total just by pointing at that order's own region cell.
You track quarterly orders for a sales organization split across regions, and the rows stay in whatever order they were entered rather than grouped by region. Finance pools bonus money by region, and a region only shares in the pool if its combined revenue across all its orders this quarter reaches $9,000. In column D, use SUMIFS to total the revenue for each order's own region, so every order from the same region shows that region's full total. In column E, mark each order "Yes" if its region's total meets the $9,000 threshold, otherwise "No". Fill in rows 2 through 6.
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.