To apply the AVERAGE function, follow these steps:
- select the cell where you wish to display the result,
- switch to the Formula tab,
- click the More functions button at the top toolbar,
- select the Statistical menu item,
- choose the AVERAGE function from the list,
- enter the required arguments separating them by commas.
Alternatively, you can add the AVERAGE function in one of the following ways:
- start adding the function:
- switch to the Home tab, click the Insert Function
icon situated at the top toolbar and select the Additional option,
- or right-click within a selected cell and select the Insert Function option from the contextual menu,
- or click the
icon situated before the formula bar,
- in the Insert Function window, select the Statistical function group from the list,
- click the AVERAGE function and press the OK button,
- enter the required arguments separating them by commas.
It's possible to add up to 255 arguments.
The arguments can be numeric values, named ranges, or references to cells or cell ranges that contain numbers. If the selected cell range contains text values, logical values and empty cells, they are ignored. Zero values (0) are counted.
When the arguments are specified, press the Enter key. The result will be displayed in the selected cell.
In this example, the average of numeric values in cells C1:C5 is calculated. Cell C1 contains text and cell C5 is empty, therefore they are ignored.
That's all. Now you can easily average multiple numbers using the AVERAGE function.