Excel & Sheets practice: Conditional Sums & Revenue Math

Chapter 6 · 4 questions · included in full access

Question 1 · easy
Revenue from the South
In K2, total the Revenue (column I) of every order from the South region.
Solve it in your browser
Question 2 · medium
Revenue for one month
Cell M1 holds the first day of a month (1-Feb-2026). In K2, total the Revenue for that whole month, using M1 so the formula works for any month typed there.
Solve it in your browser
Question 3 · medium
Each rep’s Q1 revenue
On the Reps sheet, calculate each rep's Q1 revenue from the Sales sheet. Start in E2 and fill down to E7.
Solve it in your browser
Question 4 · easy
Argument order
Which formula totals Revenue (column I) for the West region?
Solve it in your browser

These questions are part of full access.

The first chapters of every track are free. Full access is a one-time payment.

Revenue from the South