Microsoft Office Tutorials and References

In Depth Information

**Using Excel Functions**

Chapter 9

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

address.

Figure 9-7

Using the SUM function.

The following steps show you how to enter a SUM

function:

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.

1.

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.