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.

Figure 1-24

SUM function being entered with AutoSum

Excel selects the rang
e

over which the

AutoSum is applied

click to enter an

AutoSum function

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

function.

◗

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.