|1||= ( 5 + 10 + 15 ) / 3|
The most basic Excel Average Formula consists of the = sign, followed a sum of two or more values, divided by the number of values in the group.
A simple Excel average formula, that calculates the average of the three values 5, 10 and 15, is shown in cell A1 of the above spreadsheet on the right. As expected, this formula returns the result 10.
|1||= ( B1 + B2 + B3 ) / 3||5|
As with all Excel formulas, instead of typing in the numbers directly, you can use references to cells containing numbers.
The Excel average formula in cell A1 of the above spreadsheet on the right calculates the average of the values in cells B1, B2 and B3. Again, the formula returns the value 10.
Instead of using the + and / operators, as shown above, Excel provides a built-in Average function, that can be used to calculate an average in Excel. This function has the following format:
where number1, [number2], etc. are one or more numbers (or references to cells containing numbers) that you want to calculate the average of.
|1||=AVERAGE( B1, B2, B3 )||5|
An example of the Excel Average function is shown in cell A1 of the above spreadsheet on the right.
In this example, the Excel Average function is used to calculate the average of the three values in cells B1, B2 and B3. Again, the formula returns the value 10.
You can also supply a range of cells to the Excel Average function (instead of listing the individual numbers or cells).
For example, in the spreadsheet used above, in order to find the average of the values in cells B1 - B3, you could simply type the formula:
Further information and examples of the Average function are provided on the Excel Average Function page.