Course
SUMPRODUCT practice exercises
Five exercises, from your first quantity × price total to a summary table by region. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Total revenue in one formula
In F2, write a SUMPRODUCT that returns the total revenue of the orders in A1:D11: each quantity in column C times its unit price in column D, all added together.
| Region | Product | Quantity | Unit price ($) | Total revenue ($) | |
| North | Notebook | 10 | 5.00 | ||
| East | Backpack | 8 | 35.00 | ||
| South | Pen | 30 | 3.00 | ||
| North | Desk lamp | 5 | 28.00 | ||
| West | Notebook | 20 | 5.00 | ||
| North | Pen | 25 | 3.00 | ||
| South | Desk lamp | 4 | 28.00 | ||
| East | Notebook | 15 | 5.00 | ||
| North | Backpack | 6 | 35.00 | ||
| West | Pen | 40 | 3.00 |