Datasheet

121
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
To write a formula that includes a cell on another worksheet, click the
sheet tab and click the cell (the sheet name and cell reference are
entered in the formula, as shown in Figure 4.15). Click the original sheet
tab to return to the original worksheet and continue the formula, or
press Enter to finish the formula and return to the original worksheet.
Figure 4.15. This formula references a cell on another worksheet — Sheet3, cell C5.
Formulas that link workbooks
You can also write formulas that calculate cells in other workbooks. For
example, if you have workbooks that represent sales from different dis-
tricts, you can write a formula in another workbook that sums values
from the district workbooks.
To write a formula that links workbooks, open all the workbooks in
multiple windows, arranged so you have quick access to each of them.
Begin the formula with =, write your formula and click the cell in each
workbook to include it in the formula, and finish by pressing Enter. Each
referenced cell is identified by workbook name, sheet name, and cell
address, as shown in Figure 4.16.
Figure 4.16. This formula references a cell in another workbook —
Quarterly Sales.xls, sheet Qtr 1, cell C71.
Hack
If you only need to display a value from a different worksheet, start the formula
with =, then click the cell on the other worksheet that you want to display and
press Enter.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 121