OpenOffice Calc AVERAGE Function
The AVERAGE function is used to find the average of a given list of numbers in an Open Office Calc spreadsheet.
The AVERAGE Function's Syntax
The syntax for the AVERAGE function is:
=AVERAGE ( number 1; number 2; ... )
Up to 30 numbers can be averaged by the function.
The AVERAGE Function's Arguments
number 1; number 2; - the data to be averaged by the function. The arguments can contain:
- a list of numbers to be averaged
- cell references to the location of the data in the worksheet
- a range of cell references
Example: Find the Average Value of a Column of Numbers
For help with this function see the image above.
- Enter the following data into cells C1 to C6: 11, 12, 13, 14, 15, 16
- Click on cell C7 - the location where the results will be displayed
- Click on the Function Wizard icon to open the Function Wizard dialog box
- Select Statistical from the Category list
- Select Average from the Function list
- Click Next
- Drag select cells C1 to C6 in the spreadsheet to enter this range into the dialog box in the number 1 argument line
- Click OK
- The number " 13.5 " should appear in the cell C7, this is the average for the numbers entered in cells C1 to C6
- When you click on cell C7 the complete function =AVERAGE ( C1:C6 ) appears in the input line above the worksheet
Note: If the data you want to average is spread out in individual cells in the worksheet rather than in a single column or row, enter each individual cell reference into the dialog box on a separate argument line - such as number 1, number 2, number 3.Related Tutorials