Microsoft® Office 2008 for Mac Step by Step

Reference Worksheets and Workbooks

Within a formula, you aren’t limited to referencing only cells on the same worksheet. You can reference cells on other worksheets by using syntax like this:

=SUM(A5,Sheet2!C5)

Tip

You reference a worksheet by whatever name appears on its sheet tab.

This formula adds the value in cell A5 of the current worksheet to the value in cell C5 of Sheet2.

As when referencing cells on the same worksheet, you can enter a reference to a cell on another worksheet by clicking the sheet tab and then clicking the cell.

Tip

In the absence of a mathematical operator, the SUM() function adds the numeric values that have been entered in the formula and separated by commas. You can use a plus sign (+) in place of the commas if you want to, ...