Datasheet

111
CHAPTER 4
■
WORKING DATA MAGIC WITH CALCULATIONS
AutoSum
To enter a formula in the worksheet that calculates a group of numbers
without actually writing the formula yourself, use the AutoSum button
on the Standard toolbar.
AutoSum can write sum and average numbers, count all entries, and
display the maximum and minimum numbers in a range.
To use AutoSum, click a cell directly below a column of numbers you
want to sum, then click the AutoSum button (shown in Figure 4.3).
Figure 4.3. The AutoSum button on the Standard toolbar
Make sure that the moving border surrounds the cells you want to
sum (see Figure 4.4), and press Enter.
Figure 4.4. The moving border surrounds the cells that will be summed.
Hack
AutoSum can write a formula anywhere and calculate any cells you select. Click
the cell where you want the formula, click AutoSum, and then drag or Ctrl+click
all the cells you want to calculate.
09_763217 ch04.qxp 1/18/06 11:23 PM Page 111