Microsoft Office Tutorials and References
In Depth Information
Ordering Up Your Results
Figure 3–5. AutoSum in the Formulas tab
And once you appreciate how AutoSum works—and it’s rather simple—you’ll go a long way toward
firming your grasp of the whole function genre.
So let’s try the following: click on the Home tab, if you’re not already there. Delete your answer in
cell B15, stay in that cell, and click AutoSum. You should see Figure 3–6:
Figure 3–6. A more efficient way to add all those cells
Then press Enter, and presto—your answer should materialize.
You see what’s happened. AutoSum installed a function—SUM—into the cell in which you clicked, a
cell that happens to be positioned directly below the range of numbers we wanted to add; and that’s a
range SUM automatically identified. That’s why it’s called AutoSum.
But before we return to the workings of SUM in particular, note some very basic principles of Excel
functions. First, apart form the equals sign (=), an open parenthesis always follows the name of the
function—here, SUM. Then some additional information—which could be a range and/or some other
entries, as you’ll see—follows, after which the expression is concluded with a close parenthesis. To
summarize the basic syntax for any function:
=NAME(various data in here)
Remember that the equals sign always appears at the outset of any formula, e.g,
=67+SUM(B6:B15000). (Here we’re describing the basic syntax of a function considered alone.) What
kind of data gets interposed between the parentheses depends on the function, as you’ll see; here, in our
current case, SUM identifies the range to be added.
Now back to AutoSum. We see that AutoSum indeed correctly identified the range we wanted to
add—and had that range, for example, been B6:B15000 instead, we could have clicked on cell B15001,
and proceeded to click AutoSum. We’d then see this in B15001: