Excel practice · Basics

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

  1. Total your study hours
  2. Total the club's expenses
  3. Total units received
  4. Total your trivia team's points
  5. Total weekend event revenue

The exercises

1. Total your study hours Easy

You're planning your study week. Add up the Hours column to see how much total time you've scheduled.

AB
1SubjectHours
2Math5
3History3
4Chemistry4
5French2
6Economics6
7Total?

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.

2. Total the club's expenses Easy

The chess club spent money across six categories this semester. Add it all up for the treasurer's report.

AB
1CategoryAmount
2Boards120
3Trophies85
4Snacks60
5Printing25
6Venue150
7Decorations45
8Total?

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.

3. Total units received Easy

The campus bookstore logged five incoming shipments this week (row 2 just records which week it is). Find the total units received.

AB
1Week3
2ShipmentUnits
3Mon40
4Tue0
5Wed75
6Thu22
7Fri58
8Total?

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.

4. Total your trivia team's points Easy

Your trivia team played four rounds. Add up the total points scored.

AB
1RoundPoints
2118
3224
439
5431
6Total?

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.

5. Total weekend event revenue Easy

Ticket sales are listed by day, and a flat $40 in concession revenue needs to be added on top for the full weekend total.

ABCDE
1DayTicket SalesConcessions:40
2Fri180
3Sat260
4Sun150
5Total?

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 →

More basics practice

All Excel practice exercises · Excel test prep