Microsoft Office Tutorials and References
In Depth Information
Add a Row or Column of Numbers
4 Type .
C Excel displays the formula.
D Excel displays the sum in the
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.