735
Putting Worksheet Functions to Use
Two quirks in AutoSum are worth noting:
■ First, if the range above or to the left of the cell containing the SUM formulas contains
any blank cells, the range to be totaled stops there.
■ Second, when the cell that holds the SUM function is at the end of a row and a column,
AutoSum always selects the column.
In either case, the moral is the same: When using AutoSum, always check to be certain that
the correct range is selected.
To automatically add totals for several adjacent rows or columns, select the cells directly
beneath the columns or to the right of the rows and then choose an AutoSum function.
Excel plugs ...