Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUMPRODUCT. SUMPRODUCT(range1, range2) multiplies the two ranges row by row and adds up the results, all in one cell. It replaces a helper column of line totals plus a SUM. The ranges must be the same size.
=SUMPRODUCT(B2:B20,C2:C20) hours × hourly rate for a timesheet
Cedar Studios asked for the list value of everything they ordered in March, before discounts. The sheet has quantity and unit price per line but no line totals.
In G2, calculate the total list value of all lines: each quantity in C2:C8 times its unit price in D2:D8, all added up, in one formula without a helper column. No rounding.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Order | Product | Qty | Unit price | ||||
| 2 | 50203 | Trash Bags (200) | 14 | 15.00 | List value | |||
| 3 | 50203 | Hand Soap Refill 5L | 3 | 17.50 | ||||
| 4 | 50203 | Microfiber Cloths (50) | 4 | 23.50 | ||||
| 5 | 50262 | Label Roll (1000) | 14 | 9.90 | ||||
| 6 | 50262 | Copy Paper A4 (500) | 3 | 5.50 | ||||
| 7 | 50262 | Disinfectant Wipes (12) | 6 | 21.00 | ||||
| 8 | 50262 | Tea Assortment (200) | 10 | 19.90 | ||||
| 9 | ||||||||
| 10 | ||||||||
| 11 |
=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