1. Computing

Excel AVERAGE Function

Find the Average Value in a List of Data

By

Excel's Average Function

Excel's Average Function

© Ted French

The AVERAGE function can be used to find the average or arithmetic mean of a list of numbers.

The syntax for the AVERAGE function is:

= AVERAGE ( argument1, argument2, ... argument255 )

Argument1, argument 2, ... argument 255 can be numbers, named ranges, arrays, or cell references.. Up to 255 arguments can be entered.

Example Using Excel's AVERAGE Function:

  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 Formulas tab.

  4. Choose More Functions > Statistical from the ribbon to open the function drop down list.

  5. Click on AVERAGE in the list to bring up the function's dialog box.

  6. Drag select cells C1 to C6 in the spreadsheet to enter the range into the dialog box.

  7. Click OK.

  8. The answer 13.5, which is the average value for the data in cells C1 to C6, should appear in cell C7.

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

©2014 About.com. All rights reserved.