Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Using Basic Math Functions
1. Enter some numbers in a worksheet.
These numbers can be both integer and real (decimal) values. You can
add labels to adjacent cells to identify the values, if you want.
2. Position the cursor in the cell where you want the results to appear.
3. Enter =SUM ( to begin the function entry.
4. Click a cell where you entered a number.
5. Enter a comma ( ,).
6. Click a cell where you entered another number.
7. Repeat Steps 5 and 6 until all the numbers have been entered into the
function.
8. Type a ), and press the Enter key.
Figure 7-1 shows an example of how these steps help sum up amounts that
are not situated next to each other on a worksheet. Cell F6 contains the sum
of values found in cells C2, E2, G2, and I2.
Figure 7-1:
Using
the SUM
function to
noncontiguous
numbers.
Using SUM is even easier when the numbers you’re adding are next to each
other in a column or row. The SUM function lets you enter a range of cells in
place of single cells in the arguments of the function. So adding a list of
contiguous numbers is as easy as giving SUM a single argument. Here’s how you
enter a range as a single argument:
1. Enter some numbers in a worksheet.
Be sure the numbers are continuous in a row or column. You can add
labels to adjacent cells to identify the values, if desired, but this doesn’t
affect the SUM function.
2. Position the cursor in the cell where you want the results to appear.
3. Enter =SUM( to begin the function entry.
Search JabSto ::

Custom Search