Microsoft Office Tutorials and References

In Depth Information

**Add a Row or Column of Numbers**

Add a Row or

Column of Numbers

You can quickly add worksheet numbers by building a

formula that uses the Excel SUM function. When you

use the SUM function in a formula, you can specify

as the function’s arguments a series of individual

cells. For example, SUM(A1, B2, C3) calculates the

total of the values in cells A1, B2, and C3.

However, you can also use the SUM function to

specify just a single argument, which is a range

reference to either a row or a column of numbers.

For example, SUM(C3:C21) calculates the total of the

values in all the cells in the range C3 to C21.

Add a Row or Column of Numbers

1
Click in the cell where you

want the sum to appear.

2
Type
=sum(
.

A
When you begin a function,

Excel displays a banner that

shows you the function’s

arguments.

Note:
In the function banner,

bold arguments are required,

and arguments that appear in

square brackets are optional.

3
Use the Excel mouse pointer

( ) to click and drag the

row or column of numbers

that you want to add.

B
Excel adds a reference for

the range to the formula.