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
A function can be only part of a formula.
Selecting and Entering Data
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
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.