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.