Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
Maths inside SUMPRODUCT. SUMPRODUCT takes more than two ranges and multiplies all of them row by row. A range can also carry its own maths: 1-E2:E12 turns every discount into the share the customer actually pays, line by line.
=SUMPRODUCT(B2:B30,C2:C30,1-D2:D30) rent × months × (1 − vacancy)
Marcus Hill needs Copper Media’s Q2 revenue for an account review. Brightline’s revenue is quantity × unit price × (1 − discount) on every line, and a few lines had a discount.
In H2, calculate Copper Media’s revenue from the lines in rows 2 to 12: quantity (C) × unit price (D) × (1 − discount in E), added up in one formula. Round to 2 decimals.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Product | Qty | Unit price | Discount | |||
| 2 | 50277 | Espresso Beans 1kg | 6 | 24.00 | 0% | Revenue | ||
| 3 | 50285 | Hand Soap Refill 5L | 7 | 17.50 | 0% | |||
| 4 | 50285 | Sugar Sticks (1000) | 6 | 11.00 | 0% | |||
| 5 | 50359 | Whiteboard Markers (12) | 14 | 13.50 | 0% | |||
| 6 | 50359 | Paper Cups (1000) | 7 | 36.00 | 0% | |||
| 7 | 50483 | Filter Coffee 1kg | 7 | 16.50 | 10% | |||
| 8 | 50483 | Toner Cartridge Color | 6 | 84.00 | 0% | |||
| 9 | 50489 | Tea Assortment (200) | 9 | 19.90 | 0% | |||
| 10 | 50489 | Espresso Beans 1kg | 3 | 24.00 | 5% | |||
| 11 | 50489 | Ballpoint Pens (50) | 5 | 9.50 | 0% | |||
| 12 | 50489 | All-Purpose Cleaner 5L | 7 | 14.00 | 0% | |||
| 13 | ||||||||
| 14 | ||||||||
| 15 |
=IF(B2>=1.5,SUM(C2:C9),0)Language
Full plan
Excel ✓ · SQL and Power BI also included
Cancel anytime · 14-day full refund · Secure payment by Stripe