Microsoft Office Tutorials and References
In Depth Information
Creating a Total with the SUM Function
The SUM Function,
Or Any Function!
With Formula AutoComplete, you type =
and then begin typing a few letters of
the function (such as S or SU), and a
drop-down menu appears with choices
that match what you’ve typed. The list
of choices narrows as you continue to
type more letters. Whenever you see the
function you want, you can select it from
the list by highlighting it with the up or
down arrow keys and then pressing Tab
(not Enter). By the way, when a function
is highlighted in the list, a ScreenTip
appears, explaining the purpose of that
function. After making a selection from
the list, you’ll be prompted to enter the
appropriate arguments for that function.
Because the SUM function is so popular, it is
used in the following sections as an example
for how to enter functions. As you learn how
to enter the SUM function manually or with
the help of the wizard, keep in mind that
this same process may be used to enter any
function you like. Later in this chapter, you
learn about the most popular functions and
the arguments they require so you can enter
those functions properly, regardless of the
method you choose.
Entering a SUM Function
If you like entering functions by hand, Excel
provides Formula AutoComplete to help you
complete function formulas faster. Follow these
1. Click in the cell where you want the result
of the SUM function to appear.
2. Type the equals sign ( ).
3. Type SUM .
4. Type an opening parenthesis if needed. If you
selected SUM from the Formula AutoComplete
list as shown in Figure 3-3, and then pressed
Tab, then the opening parenthesis is added
Select the function you want to use from
the Formula AutoComplete list.