• Share

# Excel Web App Tutorial - AVERAGE Function

Excel Web App AVERAGE Function

Excel Web App AVERAGE Function

### Excel Web App AVERAGE Function

The AVERAGE function is used to find the average of a given list of numbers in an Excel Web App spreadsheet.

### The AVERAGE 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 AVERAGE function is:

=AVERAGE ( number1, number2, ... )

### The AVERAGE Function's Arguments

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

The argument can contain:

### Example: Find the Average Value for a Column of Numbers

For help with this function, see the image above.

1. Enter the following data into cells B1 to B6: 11, 12, 13, 14, 15, 16

2. Click on cell B7 - the location where the results will be displayed

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

4. Select Average from the Commonly Used category, or from the Statistical category

5. Click OK to start the AVERAGE 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 your keyboard to complete the function

8. The number 13.5 should appear in cell B7. This is the average of the values in cells B1 to B6

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

Note: If you want to average 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:

=AVERAGE ( B1, B3, B5 )
Related Tutorials

Ted French