Total every unit sold
Using the Units values in C2:C6, what is the overall total?
Formula: =SUM(C2:C6) → 36
Hands-on Excel exercises
Excel Practice Online
Practice Excel online in a live spreadsheet. Edit formulas, check your work, and continue with guided exercises from beginner to advanced.
Reading about spreadsheets helps, but the skill settles in when you type a formula, change an input, and see the result move. This page gives you a small live spreadsheet for exactly that kind of Excel practice online. Start the exercise, edit any cell, and test a different formula. Nothing here requires a sign-in, and resetting the grid returns the original example whenever you want another attempt.
The exercise list below moves from cell references and totals to lookups, conditional calculations, cleanup, PivotTables, and charts. Each link opens a real FormulaCamp lesson task with its own checker. The Free or Pro badge is taken from the current course access rules, so you can see the boundary before opening a lesson. If you are new, begin with cells, a first formula, and SUM. If you already work in spreadsheets, jump to lookups, error handling, or a short dashboard project.
Use the worked answers as a review after you have tried the task yourself. They pair an exact formula with its result, so you can compare your work and then change an input to make sure the calculation still responds correctly.
Your turn
Your turn: in F2, total the Lamp units sold in East.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Product | Region | Units | |||
| 2 | Lamp | East | 12 | |||
| 3 | Desk | West | 7 | |||
| 4 | Lamp | West | 9 | |||
| 5 | Chair | East | 5 | |||
| 6 | Lamp | East | 3 |
Not yet solved.
Answer: =SUMIFS(C2:C6,A2:A6,"Lamp",B2:B6,"East")
Related exercises
Open a task in its lesson.
- In A4, add the city "Phoenix".
- In D2, calculate the total for bread: price × quantity.
- In D7, calculate the total amount of the purchase.
- In E2:E4, count how many deals each manager has.
- In F2:F4, look up the item name for each code in column E.
- Fix D2 so that it gives the total revenue.
- Build a PivotTable: the sum of sales by rep, with the result in F1.
- Build a column chart of revenue by month (A1:B7).
Worked answers
Try the spreadsheet first, then compare your formula and result.
Total all East units
Using Region in B2:B6 and Units in C2:C6, how many units were sold in East?
Formula: =SUMIF(B2:B6,"East",C2:C6) → 20
Frequently asked questions
Can I practice without installing Excel?
Yes. The live exercise and lesson checkers run in the browser. They teach spreadsheet concepts and formulas without requiring a desktop installation.
Is the exercise on this page free?
Yes. The live spreadsheet on every landing page is usable without signing in. Linked lessons show their current Free or Pro access badge.
Where should a beginner start?
Start with cells and ranges, then write a first formula and use SUM. Move to IF and lookups after references feel comfortable.