• Share
Send to a Friend via Email

Your suggestion is on its way!

An email with a link to:

was emailed to:

Thanks for sharing About.com with others!

How to Quickly Sum Columns or Rows of Numbers in Excel?

Excel SUM Function Tutorial

Question: How to Quickly Sum Columns or Rows of Numbers in Excel?

The SUM function provides a quick way to sum columns or rows of numbers in an Excel worksheet.

SUM Function Syntax and Arguments

The syntax for the SUM function is:

=SUM ( Number1, Number2, ... Number255 )

Up to 255 numbers can be entered as arguments for the function.

SUM Function Example

This example will sum a column of numbers using the SUM function. The function ignores text data in the selected range.

As well, if data is later changed or numbers added to blank cells in the range, the total automatically updates to include the new data.

Entering the Tutorial Data

1. Enter the following data into cells D1 to D4: 114, 165, 178, text

2. Leave cell D5 blank

3. Enter the following data into cell D6: 165

Entering the SUM Function

1. Click on cell D7 - the location where the results will be displayed

2. Click on the Formulas tab of the ribbon menu

3. Choose Math & Trig from the ribbon to open the function drop down list

4. Click on SUM in the list to bring up the function's dialog box

5. In the dialog box, click on the Number1 line

6. Highlight cells D1 and D6 to enter this range of data into the dialog box

7. Click OK to complete the function and close the dialog box

8. The answer 622 should appear in cell D7

9. The function ignores the text data in cell D4

Updating the SUM Function

1. Enter the following data into cell D5: 200 and press the Enter key on the keyboard

2. The answer 622 in cell D7 should update to 822

3. Replace the text data in cell D4 with the number 100 and press the Enter key on the keyboard

4. The answer in D7 should update to 922

5. Click on cell D7 and the complete function = SUM (D1 : D6) appears in the formula bar above the worksheet

Ted French