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

Part 5. Working with Formulas and Functions > Using Functions Across Worksheets

Using Functions Across Worksheets

Click in the cell in which you want the result of the formula to appear (this is called the resultant cell).

Click the AutoSum button on the Standard toolbar. Excel selects the logical cells to sum.

In this example, we are going to add the sum of this operation to last year's data in another worksheet (2003), so type a + outside the right bracket.

Click the tab of the worksheet that contains the cell you want to reference in the calculation.

INTRODUCTION

You can use cell references from other worksheets in your calculations. For example, suppose you have two worksheets that contain the calculations for the total sales by region for a particular year. In a third worksheet, you want to calculate the total sales by region for the last two years. You can reference the cells in the first two worksheets that contain the totals and perform calculations on them in the third worksheet.


TIP

Worksheet name references

Instead of switching back and forth between worksheets, you can reference the worksheet name in your calculations. The location of a cell in a particular worksheet is the cell row and column location in addition to the sheet name—for example, Sheet1!A1.


Click the cell that you want to use in your calculation; it appears next to the worksheet name in the Formula bar.

Press the Enter key. Excel performs the calculation and returns you to the original worksheet.

Click the resultant cell to make it the active cell. Notice that the function is displayed in the Formula bar.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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