Loading exercise…
Loading exercise…
Exercises are built for a keyboard. Read the task here, then open this page on a laptop to solve it.
SUM. SUM adds up a whole list in one go. Give it a range: the first cell, a colon, and the last cell. The range covers every cell in between.
=SUM(C2:C9) adds C2, C3 … down to C9
The stockroom wants the total boxes of everything on the list.
In B5, total the boxes of all three items with SUM.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Item | Boxes | ||||||
| 2 | Paper | 8 | ||||||
| 3 | Pens | 12 | ||||||
| 4 | Staplers | 5 | ||||||
| 5 | Total | |||||||
| 6 | ||||||||
| 7 | ||||||||
| 8 |
=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