Microsoft Office Tutorials and References
In Depth Information
Add a Row or Column of Numbers
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