Course
Formulas across sheets: practice exercises
Five exercises, from one cell on another sheet to a price lookup across sheets. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Read the tutorial on referencing another sheet
Exercise 1 of 5
Bring a total from another sheet
January’s sales are on the Jan sheet, with the month’s total in B5. Click the tabs under the grid (or press Ctrl + Page Down) to look at it, then come back to Summary. In B2, show that total with a reference to the other sheet.
| Month | Sales ($) |
| January |