Microsoft Office Tutorials and References
In Depth Information
Creating a Total with the SUM Function
Using AutoSum to Enter Other Functions
The AutoSum button is not a single purpose
gadget—nope, it can be used to enter a variety
of very common functions into your
worksheet. Here’s a brief description of each one—
you learn more about each of these functions
later in this chapter:
2. Click the arrow on the AutoSum button on
the Home tab. A menu appears, as shown in
AVERAGE: Calculates the average of a
group of cells
COUNT: Counts the number of cells in
a range that contain values, whether
it’s text, a number, or something else
The AutoSum button allows you to enter
other functions besides SUM.
MIN: Displays the minimum value in a
MAX: Displays the maximum value in a
3. Select the function you want to use from those
listed. For example, click Count Numbers.
To enter any one of these functions using the
AutoSum button, follow these steps:
4. The function you selected is inserted into the
result cell. Unless you preselected a range,
AutoSum makes a guess as to which adjacent
cells you want to use, highlighting those cells
with a marching ants border (see Figure 3-8).
If you don’t like this guess, drag over the
range you really want to use to select it.
1. Click in the cell where you want the result of
the function to appear. Again, keep in mind
that Excel is better capable of guessing the
range to use if you put your result cell
adjacent to the cells you want to use with the
function. If you don’t want to do that, select
the range to use, and click the AutoSum
button to prevent Excel from wasting your
time with a wrong guess.
5. To enter another argument, type a comma
and drag over an additional range to select it.
6. Press Enter to complete the formula. The
result of the selected function appears in the