Exercises / Conditional counting and sums · 10 of 11
Total revenue in one formula
SUMPRODUCT(range1, range2) multiplies the ranges row by row and adds the results: price × quantity for every line, summed. No helper column needed.
Your taskIn F2, use SUMPRODUCT to work out total revenue: each price in B2:B8 times its quantity in C2:C8, all added up.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B | C | D | E | F |
|---|---|---|---|---|---|---|
| 1 | Product | Price | Qty | Measure | Value | |
| 2 | Notebook | $3.50 | 120 | Revenue | ||
| 3 | Pen set | $6.00 | 85 | |||
| 4 | Stapler | $12.90 | 24 | |||
| 5 | Desk lamp | $24.00 | 31 | |||
| 6 | Backpack | $39.99 | 18 | |||
| 7 | Monitor arm | $58.00 | 9 | |||
| 8 | Desk mat | $19.50 | 40 |