Home » Excel-Formulas » Excel-Average-Formula

# Simple Excel Average Formula

## Excel Average Formula Using The + and / Operators

| A | B |
---|

1 | = ( 5 + 10 + 15 ) / 3 | |
---|

2 | | |
---|

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*.

| A | B |
---|

1 | = ( B1 + B2 + B3 ) / 3 | 5 |
---|

2 | | 10 |
---|

3 | | 15 |
---|

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*.

## Using the Excel Average Function

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:

=AVERAGE( number1, [number2], ... )

where number1, [number2], etc. are one or more numbers (or references to cells containing numbers) that you want to calculate the average of.

| A | B |
---|

1 | =AVERAGE( B1, B2, B3 ) | 5 |
---|

2 | | 10 |
---|

3 | | 15 |
---|

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*.

### Supplying a Range of Cells to the Average Function

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:

=AVERAGE( B1:B3 )

This is much quicker than typing multiple cell references, particularly if you have a large set of values that you want to calculate the average of.

Further information and examples of the Average function are provided on the Excel Average Function page.