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