Microsoft Office Tutorials and References

In Depth Information

**Add a Row or Column of Numbers**

6

chapter

Building Formulas

4
Type
.

5
Click

or press

.

C
Excel displays the formula.

D
Excel displays the sum in the

cell.

Can I use the SUM function to total rows and

columns at the same time?

Yes, the SUM function works not only with

simple row and column ranges, but with any

rectangular range. After you type
=sum(
, use

the mouse to click and drag the entire

range that you want to sum.

Can I use the SUM function to total only

certain values in a row or column?

Yes. The SUM function can accept multiple

arguments, so you can enter as many cells or

ranges as you need. After you type
=sum(
,

hold down and either click each cell

that you want to include in the total, or use

the mouse to click and drag each range

that you want to sum.