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.