Datasheet

22
Part I: Putting the Fun in Functions
Figure 1-15:
Completing
the formula.
Figure 1-16:
A finished
formula.
Understanding references
References abound in Excel formulas. You can reference cells. You can refer-
ence ranges. You can reference cells and ranges on other worksheets. You
can reference cells and ranges in other workbooks. Formulas and functions
are at their most useful when using references, so you need to understand
them.
And if that isn’t enough to stir the pot, you can use three types of cell refer-
ences: relative, absolute, and mixed. Okay, one step at a time here. Try a for-
mula that uses a range.
Formulas that use ranges often have a function in the formula, so use the
SUM function here:
05_568163-ch01.indd 2205_568163-ch01.indd 22 4/2/10 1:37 PM4/2/10 1:37 PM