Microsoft Office Tutorials and References
In Depth Information
Using Excel Functions
Working with Formulas and Functions
Function results Function
Selecting Cells with the Mouse
Instead of typing cell addresses, you can use
your mouse to select the desired cells.
Highlighting the cells with the mouse
instead of typing them makes it easier to see
that you have selected the correct cells.
2. Type the cell addresses you want to add
together, using a colon or comma to separate
the addresses. As you type the cell addresses,
Excel puts a border around the cells so you
can quickly see if you typed the correct cell
Using the SUM function.
The following steps show you how to enter a SUM
3. Type a closing parenthesis and then press the
Enter key. The resulting value appears in the
cell, but the Formula bar still reflects the
function and its arguments.
Click in the cell where you want the total of
the values to display. Type an equals sign (=).
The blinking insertion point appears after the
equals sign, but do not press the Enter key
until the function is complete. Type the word
SUM and then type an opening parenthesis.
Using the AutoSum Button
Since the SUM function is the function used most,
Microsoft includes a button for it on the Ribbon. In
fact, you’ll find the AutoSum button on the Ribbon
twice—once on the Home tab and again on the
Formulas tab. The AutoSum button looks like this
The arguments for a SUM function require
that you enter the cell addresses you want to
add. When you enter function arguments,
you type the cell addresses you want to add.
If the cell addresses are adjacent to each
other, you separate them with a colon (:). For
example, typing B2:B5 will add the values in
B2 plus B3 plus B4 plus B5. If the cell
addresses you want to add are not adjacent,
you separate them with a comma. For
example, entering B2, B5, B13 will add the values
in cells B2 and B5 and B13 but not the value
of any cells in between. You can also
combine adjacent and non-adjacent cells, such as
B2, B5, B13:B15, which would add the values
in cells B2 and B5 and B13, B14, and B15.
(a Sigma). Using the AutoSum button makes
creating a simple addition formula a mouse click
away! Begin with these steps:
1. Click the cell below or to the right of the
values you want to total.
2. Choose Home>Editing>AutoSum or
Formulas>Function Library>AutoSum. The
cells to be totaled are highlighted. Excel first
suggests the values in the cells directly above
it (see Figure 9-8), but if no values are
directly above the current cell, Excel looks for
values in the cells to the left.