• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 16. Special Excel Techniques > Referring to Data from Other Sheets in F...

Referring to Data from Other Sheets in Formulas

While you are building a formula, you can include data from another sheet.

To build a formula using data from another sheet:

1.
Click the destination cel for the formula.

2.
Start the formula by typing an equal sign, a left parenthesis, a cell, and then an operator (Figure 16.6).

Figure 16.6. Type the formula.


3.
Refer to cells on another sheet by switching to the sheet and then selecting the cell or cells (Figure 16.7).

Figure 16.7. Switch to another sheet and select the cell or cells to include in the formula.


4.
Press Enter when you finish building the formula (Figure 16.8).

Figure 16.8. Press Enter to complete the formula.


You will be returned to the sheet on which you started the formula and the formula appears (Figure 16.9).

Figure 16.9. The formula.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint