Datasheet

110
PART II
■
GETTING THE DATA IN
Figure 4.1. AutoCalculate is always at work. All you need to do is select two or more cells.
To use AutoCalculate, select the cells you want to calculate (two or
more) and look at the AutoCalculate box.
AutoCalculate sums cells by default, but it can also average cells,
count entries, count numeric entries, and tell you the maximum or min-
imum number in a range.
To change the calculation function, right-click anywhere in the Status
bar and select a different function (see Figure 4.2). You can turn
AutoCalculate off by selecting None, but it’s so unobtrusive that many
people never even notice it, so why bother turning it off?
If there’s no display in the AutoCalculate box (and it’s not turned
off), that’s because you only have one cell selected, or you don’t have
appropriate data selected for the current AutoCalculate function. For
example, if you only have text cells selected, only the Count function
works.
Figure 4.2. Changing the AutoCalculate function
Right-click anywhere in the Status bar
AutoCalculate
09_763217 ch04.qxp 1/18/06 11:23 PM Page 110