Note: These instructions will work for all versions of Excel from Excel 95 to Excel 2007.
Related article: Excel 2007 AVERAGE Function
Excel�s AVERAGE function is one of the �Statistical Functions� that are included with the program.
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:
Note: For help with this example, see the image to the right.
- 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.
- Type � = average( � in cell C7.
- Drag select cells C1 to C6 with the mouse pointer.
- Type the closing bracket " ) " after the cell range in cell C7.
- Press the ENTER key on the keyboard.
- The answer - 13.5 - should be displayed in cell C7.
- The complete function = AVERAGE (C1 : C6) appears in the formula bar above the worksheet.


