Excel AVERAGE Function

Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2010.

Related tutorial: Excel 2007 / 2010 AVERAGE Function

The AVERAGE function can be used to find the average, or arithmetic mean, of values in a selected range of cells.

The function is written as follows:

= AVERAGE (argument)

The argument for this function is data contained in the selected range of cells.

Example Using Excel's AVERAGE Function:

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. Type " = average( " in cell C7.
   
   
4. Drag select cells C1 to C6 with the mouse pointer.
   
   
5. Type the closing bracket " ) " after the cell range in cell C7.
   
   
6. Press the ENTER key on the keyboard.
   
   
7. The answer - 13.5 - should be displayed in cell C7.
   
   
8. The complete function = AVERAGE (C1 : C6) appears in the formula bar above the worksheet.