Spreadsheets- Advanced Calculations

Creating multisheet formulas

If you needed to calculate a sum of several sheets you could create a 3D formula which would read through all of the pages and create a formula. All pages must be set up exactly the same way.

1. Go to the page where you want to create the summary formula
2. Click in the cell where you want the formula
3. Type "=" function "("
4. Click on the last sheet tab which contains the data
5. Click in the cell you wish to calculate
6. Hold the SHIFT key
7. Click on the sheet tab of the first sheet tab that has the data you need to calculate
8. Press Enter

   

Example:
=SUM(Sheet3!B1:B3)

Linking cells across sheets

It is often helpful to link cells in a spreadsheet on other worksheets. This way your data is automatically updated if you edit the data on other sheets and you can build other page layouts using the same information.

To link cells:

1. Click on the worksheet you want the linked cell
2. Click in the cell you want the formula
3. Type "="
4. Go to the worksheet that has the data you want to link
5. Click in the cell
6. Type ENTER