SUM: add up a range
Exercise 1 of 3
The sheet shows one week of sales. In B7, add up the sales in B2:B6.
About this lesson
SUM adds up a range, several ranges or single cells. It's the first function most people learn, and the one they use most.
In this lesson
- The sheet shows one week of sales. In
B7, add up the sales inB2:B6. - Steps walked are in a row this time. In
H2, add upB2:G2. - Two shops, four weeks. In
B7, add up every sale from both shops with one SUM.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in B7 and press Enter to check.