Microsoft Office Tutorials and References
In Depth Information
Creating a Total with the SUM Function
Entering a SUM Function with
the AutoSum Button
Again, entering a SUM function into a worksheet
is a pretty popular thing to do—so popular in
fact, that Excel provides you with a shortcut way
in which to enter it: the AutoSum button. So
instead of tediously entering a formula such as
=C3+D3+E3+F3+G3, you can use the AutoSum
button to use the SUM function instead:
=SUM(C3:G3). Here’s how:
1. Click in the cell where you want the result of
the SUM function to appear. As you learn in
Step 3, AutoSum works best if you put your
result cell adjacent to the cells you want to
The AutoSum button allows you to enter
the SUM function quickly.
2. Click the AutoSum button on the Home tab,
as shown in Figure 3-8.
4. To sum more than one range, type a comma
and drag over an additional range to select it.
3. As soon as you click the AutoSum button, it
takes a guess as to which adjacent cells you
might want to sum, and it highlights those
cells with a marching ants border (see Figure
3-8). If you don’t like this guess (which you
won’t, if your result cell is not located right
next to the cells you want to sum), just drag
over the range you really want to sum to
5. Press Enter or Tab to complete the formula.
The result of the SUM function appears in
the result cell.
Before entering a second argument for
the SUM function, make sure that the
cursor is positioned at the end of the
first range address. If you manually
selected the first range, the cursor is
already in the right spot; if you like
Excel’s guess, keep it and simply click
at the end of that range address in the
Formula bar. Then type your comma and
add the second range address.
If the result cell is not right next to the
cells you want to use in the SUM function,
you might want to beat Excel to the
punch and select the cells to add first by
clicking the AutoSum button. Excel will
not try to guess which range you want to
sum, but will instead simply display the
selected range as the first argument.