SUM practice exercises
5 graded problems with realistic data, all easy.
Adds every number you give it: cells, ranges, or typed values, in any mix. The 5 exercises below come from LearnExcel's practice library. Each one gives you a realistic table, a cell to fill, and a hint if you get stuck. Read them here, then solve them in the interactive grid, where your formula is checked the moment you press Enter.
New to the function? Read the SUM guide first: syntax, a worked example and the mistakes people make.
In this set
- Total your study hours
- Total the club's expenses
- Total units received
- Total your trivia team's points
- Total weekend event revenue
The exercises
You're planning your study week. Add up the Hours column to see how much total time you've scheduled.
| A | B | |
|---|---|---|
| 1 | Subject | Hours |
| 2 | Math | 5 |
| 3 | History | 3 |
| 4 | Chemistry | 4 |
| 5 | French | 2 |
| 6 | Economics | 6 |
| 7 | Total | ? |
Enter a formula in B7.
Show a hint
Add every value from B2 through B6. Try SUM with a range, like =SUM(B2:B6).
Totaling a column is the single most common thing you'll do in Excel: budgets, grades, expense reports, anything tabular.
The chess club spent money across six categories this semester. Add it all up for the treasurer's report.
| A | B | |
|---|---|---|
| 1 | Category | Amount |
| 2 | Boards | 120 |
| 3 | Trophies | 85 |
| 4 | Snacks | 60 |
| 5 | Printing | 25 |
| 6 | Venue | 150 |
| 7 | Decorations | 45 |
| 8 | Total | ? |
Enter a formula in B8.
Show a hint
Same idea as any SUM, just one more row in the range: =SUM(B2:B7).
A treasurer's report is just SUM applied to real money. This is what club and small-team budgeting looks like in practice.
The campus bookstore logged five incoming shipments this week (row 2 just records which week it is). Find the total units received.
| A | B | |
|---|---|---|
| 1 | Week | 3 |
| 2 | Shipment | Units |
| 3 | Mon | 40 |
| 4 | Tue | 0 |
| 5 | Wed | 75 |
| 6 | Thu | 22 |
| 7 | Fri | 58 |
| 8 | Total | ? |
Enter a formula in B8.
Show a hint
A 0 in the range is still just a number. SUM adds it in fine: =SUM(B3:B7).
Inventory counts are almost always a running SUM across incoming or outgoing batches.
Your trivia team played four rounds. Add up the total points scored.
| A | B | |
|---|---|---|
| 1 | Round | Points |
| 2 | 1 | 18 |
| 3 | 2 | 24 |
| 4 | 3 | 9 |
| 5 | 4 | 31 |
| 6 | Total | ? |
Enter a formula in B6.
Show a hint
=SUM(B2:B5) covers all four rounds.
Score totals across rounds, games, or matches are one of the most natural uses of SUM.
Ticket sales are listed by day, and a flat $40 in concession revenue needs to be added on top for the full weekend total.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Day | Ticket Sales | Concessions: | 40 | |
| 2 | Fri | 180 | |||
| 3 | Sat | 260 | |||
| 4 | Sun | 150 | |||
| 5 | Total | ? |
Enter a formula in B5.
Show a hint
SUM can mix a range with a single extra cell in the same call: =SUM(B2:B4,E1).
Real totals rarely come from one clean range. Mixing a range with a few extra values in one SUM is normal.
Solve these in a real grid
Type your formula, get graded instantly. Your first 10 exercises are free, no signup.
Start the SUM exercises →