Microsoft Office Tutorials and References
In Depth Information
Using Ranges on Other Sheets in Formulas
Now, because we’re working with a
range, we could use the
function. Let’s say you click in cell
C12 on Sheet1, where you want the
answer to appear. You can then
click the AutoSum button, and you’ll
see what’s shown in Figure 9–21.
Figure 9–21. Where’s the range between the
You won’t see any cell references
yet, because there are no values in
the column above C12, nor are there
any in the row to C12’s left (values
that AutoSum is programmed to
look for—but that doesn’t bother us,
because the values we want to add
are on Sheet2 anyway). Next, click
the Sheet2 tab and simply drag the
range you want, as in Figure 9–22.
Figure 9–22. Dragging the range on Sheet2. Again,
note how the formula bar records this expression.
Then just click OK or click the check mark. On Sheet1, you’ll see the
answer, as shown in Figure 9–23.
Figure 9–23. The answer, recorded in cell C12 on Sheet1