When creating a formula, it is possible to use data on another worksheet within the same workbook by including the worksheet name within the formula.
Please load the “Multiple Worksheets” Excel workbook.
In the workbook, there are two sheets in use, one named “Total” and one named “Data”.
The “Total” worksheet will contain the totals from the “Data” worksheet.
The “Data” worksheet contains figures to be incorporated into the “Total” worksheet.
Cell B2 in the “Total” worksheet needs to contain the total of the January column from the “Data” worksheet.
- Highlight cell B2 on the “Total” worksheet
- Enter =sum( (to indicate a formula)
- Move to cell B2 on the “Data” worksheet and highlight cells B2 to B5 and then type ) and hit Enter.