Work with cell references across sheets

You can refer to cells in other sheets and use their content in the calculation.

Procedure

  1. Open a spreadsheet.
  2. Enter the relevant formula with the reference to another sheet as shown in the example, for example, =SUM('Sheet 1'!A1:F1).

    In general, the entry is made in the following way: =SUM('<sheet name>'!<cell name1>:<cell name2>).

The values from the sheet defined in the formula are used for the calculation.

Example

The relevant values for the calculation are located on sheet 1:

References across sheets - 1

The calculation is carried out on sheet 2:

References across sheets - 2