Microsoft Office Tutorials and References
In Depth Information
Entering Functions with the AutoSum Feature
How AutoSum Works
Excel determines the range reference needed for the function being inserted by the
AutoSum feature by examining the layout of the data and choosing what seems to be the
most likely range. When you use the Sum button, Excel highlights the range it thinks you
want to use. For example, if you use the Sum button in a cell that is below a column of
numbers, Excel assumes that you want to summarize the values in the column. You can
change that range by typing a different range reference or selecting a different range.
Make sure to always verify the range AutoSum selected, especially when a
worksheet’s column or row titles contain numbers. AutoSum cannot differentiate between
numbers used as titles (such as years) and numbers used as data for the calculation.
Amanda wants to calculate the total revenue she’ll generate after she fulﬁ lls her
customer orders. You’ll use the AutoSum feature to enter the SUM function.
To calculate the total revenue using the AutoSum feature:
1. Click cell H10 to make it the active cell.
2. In the Editing group on the Home tab, click the Sum button arrow .
The button’s menu opens and displays five common summary functions: Sum,
Average, Count Numbers, Max (for maximum), and Min (for minimum).
3. Click Sum to enter the SUM function. See Figure 1-24.
SUM function being entered with AutoSum
Excel selects the rang e
over which the
AutoSum is applied
click to enter an
into the selected cell
Excel inserts the SUM
function and the most
likely cell reference
4. Verify that the range H6:H9 appears in the SUM function and is highlighted with
a dotted border. The dotted border shows what will be included in the SUM
5. Press the Enter key to accept the automatically generated formula. The total
charge for all of Amanda’s customers, shown in cell H10, is $1,160.81.