Entering a formula that references another worksheet

• To develop a formula that references cell D10 in the Sales worksheet

=Sales!D10

The exclamation point separates the sheet reference (Sales) from the cell reference (D10).

• If a worksheet name contains one or more spaces, enclose the sheet name in single quotation mark.
  

= 'Sales Data'!D10

To enclose the sheet name in single quotation marks

• To create a formula that adds total sales from two worksheets

=Domestic!B10 + International!B8