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

OpenOffice Calc Tutorial - AVERAGE Function

By

OpenOffice Calc AVERAGE Function
OpenOffice Calc Tutorial - AVERAGE Function

OpenOffice Calc Tutorial - AVERAGE Function

© Ted French

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

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 ( 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:

Example: Find the Average Value of a Column of Numbers

For help with this function see the image above.

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

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

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

  4. Select Statistical from the Category list

  5. Select Average from the Function list

  6. Click Next

  7. Drag select cells C1 to C6 in the spreadsheet to enter this range into the dialog box in the number 1 argument line

  8. Click OK

  9. The number " 13.5 " should appear in the cell C7, this is the average for the numbers entered in cells C1 to C6

  10. 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

©2014 About.com. All rights reserved.