Microsoft Office Tutorials and References
In Depth Information
Using Ranges on Other Sheets in Formulas
The formula first refers to the value on Sheet1, 23000. We then clicked the other cell
whose value we wanted to add, also called A3, but on Sheet2, and that’s why we had to
click the Sheet2 tab first. In order to distinguish between the two A3s, Excel added the
Sheet2!
prefix when we clicked that sheet’s A3.
That’s how Excel works with cells in different sheets—by supplementing cell addresses
with the name of the sheet in which the cell is positioned. And if you’re asking why the
first A3 wasn’t preceded by the prefix
Sheet1!
in our formula, good question. It’s
because Excel assumes by default that any cells referred to in a formula are on the same
sheet as the formula. It’s only when a cell is located elsewhere that the prefix is needed.
Using Ranges on Other Sheets in Formulas
Your ability to write formulas and functions that call upon cells in other sheets isn’t
restricted to individual cells. It’s easy to work with whole ranges, too.
Say you have a range of values on Sheet2, C11:C15, whose sum you want to calculate
on Sheet1 (see Figure 9–20).
Figure 9–20. Values on Sheet2
1.
To start the process, click in the cell on Sheet1 in which you want the
answer to appear.
3
 
Search JabSto ::




Custom Search