3-D cell references

Ability enables you to create formulas that use data from cells in different sheets in the same workbook. Cross-sheet formulas can access the data from specified individual cells or can work with ranges of data over several sheets (3-D cell references).

For example, you may want to sum the same range, say A1 to A5, in Sheets 1, 2 and 3, so that the result is the sum of all three ranges in the three sheets (hence the 3-D aspect).

To do this you would enter either of the following formulas in the cell where you want the result to appear (the cell for the result can be anywhere you like):

=SUM(Sheet1!A1:Sheet3!A5)

=SUM(Sheet1:Sheet3!A1:A5)

Once you have entered the formula (press the Return key or click on the Confirm button) the calculation will be made immediately and its result displayed in the same cell.