1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Excel Web App Tutorial - SUM Function


Excel Web App SUM Function
Excel Web App SUM Function

Excel Web App SUM Function

© Ted French

Excel Web App SUM Function

Adding up rows or columns of numbers is one of the most common operations carried out in spreadsheet programs like Excel Web App.

To make it easier to accomplish this task, Excel Web App includes a built in formula called the SUM function.

The SUM Function's Syntax

A function's syntax refers to the layout of the function and includes the function's name, brackets, and arguments.

The syntax for the SUM function is:

=SUM ( number1, number2 )

The SUM Function's Arguments

number1, number2 - the data to be summed by the function.

The arguments can contain:

Example: Add a Column of Numbers using the SUM Function

For help with this function, see the image above.

  1. Enter the following data into cells B1 to B6: 114, 165, 178, 143, 130, 165

  2. Click on cell B7, the location where the results of the function will be displayed

  3. Click on the Insert Function icon to open the Insert Function dialog box

  4. Select SUM from the Commonly Used category or the Math & Trig category

  5. Click OK to start the SUM function in cell B7

  6. Drag select cells B1 to B6 to enter this range as the function's argument

  7. Press the ENTER key on the keyboard to complete the function

  8. The number 895 should appear in cell B7

  9. When you click on cell B7 the complete function =SUM ( B1:B6 ) appears in the formula bar above the worksheet

Note: If you want to add up data that is spread out in individual cells in the worksheet rather than in a single column or row, click on each number to enter it into the function and separate the cell references with a comma ( , ).
For example:

=SUM ( B1, B3, B5 )
Related Tutorial

©2014 About.com. All rights reserved.