Excel 2007 AVERAGE Function

The AVERAGE function, one of Excel's statistical functions, is used to find the average or arithmetic mean of a given list of arguments.

Related article: Excel 2003 AVERAGE Function

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:

Note: For help with this example, see the image to the right.

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 should appear in cell C7.
   
   
9. The complete function = AVERAGE (C1 : C6) appears in the formula bar above the worksheet.

• Excel 2007 AVERAGE IF
• Excel 2007 MAX Function
• Excel 2007 MIN Function