Microsoft Office Tutorials and References

In Depth Information

**Creating a Total with the SUM Function**

Also, as you enter arguments for a function,

Excel calculates the current result and displays

it just below the last argument. At the bottom

of the dialog box, Excel displays the result of

the entire formula, which might be different.

For example, consider the formula shown in

Figure 3-7, in which the function, SUM, is

only part of the formula. In that example,

I am trying to calculate the net pay for an

employeeâ€™s paycheck. So the formula takes

the value in cell I8 (the gross pay) and

subtracts the total of all the deductions (which

is calculated using SUM). So, in the Function

wizard, the result shown under the last

argument (150.171) is the total of all the

deductions. At the bottom of the dialog box,

the result of the formula (the next pay) is

displayed: $219.83.

Figure 3-7

A function can be only part of a formula.

Selecting and Entering Data

7.

To enter another argument, click in the

second argument box, and then type its value.

In this case, you can click the second

argument box and enter another range for SUM

to add up. Repeat this step to enter more

arguments.

A simpler way to enter a range address into

an argument box is to select it. To do that,

click the Collapse button at the right end

of the argument box (see Figure 3-6). The

Function wizard collapses to show only the

argument box. This collapsing business

essentially gets the wizard out of the way so

you can get down to selecting the range you

want to use. Anyway, go ahead and drag over

the cells in the range you wish to select. To

expand the wizard again, click the Expand

(formerly Collapse) button.

8.
Click OK to enter the function.