Datasheet

114
PART II
■
GETTING THE DATA IN
When you write formulas that include cells, the cells in the formula
are identified by their references. For example, in Figure 4.8, the for-
mula =A1+B1 sums the values in cells A1 and B1.
Figure 4.8. Formulas use cell references.
A range reference is a rectangular range of cells that are identified by
the references of the range’s upper-left corner cell and lower-right cor-
ner cell. The references are separated by a colon (:), as in the range ref-
erence A1:B6 (see Figure 4.9).
Figure 4.9. This SUM formula uses a range reference.
Cell reference types
Cells can have different types of references, depending on how you want
to use them in the formula. First, I explain the terminology and how to
create the different types; then I show you how they work with actual
examples (at which point they’ll make more sense).
This range reference...
...refers to this range.
This formula...
...references these two cells.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 114