Day 78 · Tuesday, 20 October 2026

From the archive

Intermediate

Total each order's region revenue with SUMIFS and check it against a bonus threshold

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.

Task:

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.

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.

Every day so far

August 2026

September 2026

October 2026

November 2026

18
SolvedOpenProLatest

Recent days

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