Microsoft Office Tutorials and References
In Depth Information
Doing a Multi-sheet Calculation
A7—you can write a sum formula, anywhere, on any sheet, which totals the three salaries. (And in fact
the salaries don’t have to be entered in the same cell address on the respective sheets. They can be
situated in any cells.)
Doing a Multi-sheet Calculation
But let’s start with a simpler case—you want to add two numbers on different sheets:
1.
On Sheet 1 type 56 in cell D12.
2.
On Sheet 2 enter 48 in cell B3. (Remember that the formula referencing these
two cells can be written on any sheet—even Sheet 3, but we’ll enter ther
formula on Sheet 1.)
3.
Click back on Sheet 1, onto cell A21. Once there, type the usual, and necessary,
= sign.
4.
Click on cell D12, the cell in Sheet 1 containing 56. You’ll see:
=D12
Nothing new so far. Then:
5.
Type the + sign, simply because we’re about to add the contents of two cells.
6.
Click the Sheet 2 tab, and click on cell B3. You’ll see (Figure 7–11):
Figure 7–11. Writing a formula in Sheet1, including a cell in Sheet2
Note the budding expression in the formula bar: =D12+Sheet2!B3. By clicking on cell B3, the
formula supplements that cell reference with the Sheet2! prefix, and why? Because, remember—we’re
actually writing this formula in cell A21 on Sheet 1, and so we need to indicate which cell B3 we’re now
referring to. After all, that cell could be in Sheet 1, Sheet 2, or Sheet 3—or any other sheet we might
have inserted into the workbook. As a result, Sheet2! is Excel’s way of notifying the formula that we
want to call upon the B3 in Sheet 2. T he n pr e ss En te r , an d we ’ r e sn appe d back to She e t1, an d the
 
Search JabSto ::




Custom Search