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:
- a list of numbers to be included
- cell references to the location of the data in the worksheet
- a range of cell references
Example: Find the Average Value for a Column of Numbers
For help with this function, see the image above.
- Enter the following data into cells B1 to B6: 11, 12, 13, 14, 15, 16
- Click on cell B7 - the location where the results will be displayed
- Click on the Insert Function icon to open the Insert Function dialog box
- Select Average from the Commonly Used category, or from the Statistical category
- Click OK to start the AVERAGE function in cell B7
- Drag select cells B1 to B6 to enter this range as the function's argument
- Press the ENTER key on your keyboard to complete the function
- The number 13.5 should appear in cell B7. This is the average of the values in cells B1 to B6
- 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
