Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Using Basic Math Functions
Here’s how you use SUM to add the values in multiple ranges:
1. Enter some lists of numbers in a worksheet.
You can add labels to adjacent cells to identify the values, if desired.
2. Position the cursor in the cell where you want the results to appear.
3. Enter =SUM( to begin the function entry.
4. Click the first cell in a range and, while holding down the left mouse
button. drag the mouse over all the cells in the range, and then
release the mouse button.
5. Enter a comma ( ,).
6. Click the first cell in another range and, while holding down the left
mouse button, drag the mouse over all the cells in this range, and then
release the mouse button.
7. Repeat Steps 5 and 6 until all the ranges have been entered into the
function.
8. Type a ), and press the Enter key.
The completed function entry should look similar to the entry shown in the
Formula Bar in Figure 7-3. Each range is separated by a comma, and a grand
sum is in the cell where the function was entered.
When entering ranges into a formula, you can either type them in or use the
mouse to drag over the range.
Excel has a special button, the AutoSum button, that makes it easier to use
the SUM function. The AutoSum button is on both the Home tab and the
Formulas tab on the Ribbon. The AutoSum feature works best with numbers
that are in a vertical or horizontal list. In a nutshell, AutoSum creates a range
reference for the SUM function to use. AutoSum makes its best guess of what
the range should be. Often, it gets it right — but sometimes you have to help
it along.
Using AutoSum is as easy as a click and pressing the Enter key. Figure 7-4
shows that the AutoSum button on the Ribbon has been clicked, and Excel,
in its infinite wisdom, guessed correctly that the operation is to sum cells
B6:B13. At this point the operation is incomplete. Pressing the Enter key
finishes the formula.
Search JabSto ::

Custom Search