# A Complete Guide to the AVERAGE() Function in Microsoft Excel: Explanation, Examples, and Key Features

The AVERAGE() function in Microsoft Excel is use to calculate the average (arithmetic mean) of a set of numeric values. This function can be used to average a range of cells or a set of numbers that are separated by a comma.

### Examples of using the AVERAGE() function:

1. Firstly, use to find the average of a range of cells: =AVERAGE(A1:A10)
2. To find the average of a set of numbers: =AVERAGE(1,2,3,4,5)
3. To find the average of a combination of ranges and numbers: =AVERAGE(A1:A10, 20, 30)
4. To find the average of only specific values within a range: =AVERAGE(IF(A1:A10>5,A1:A10))
5. To find the average of a dynamic range: =AVERAGE(INDEX(A1:A10,1):INDEX(A1:A10,COUNT(A1:A10)))
6. To find the average of a column excluding zeros: =AVERAGEIF(A1:A10,”>0″)
7. To find the average of a column excluding specific text: =AVERAGEIF(A1:A10,”<>No Data”)
8. To find the average of top n values within a range: =AVERAGE(LARGE(A1:A10,ROW(INDEX(A1:A10,1):INDEX(A1:A10,3))))
9. To find the average of bottom n values within a range: =AVERAGE(SMALL(A1:A10,ROW(INDEX(A1:A10,1):INDEX(A1:A10,3))))
10. Lastly, ro find the average of the most frequent value within a range: =MODE(A1:A10)

Notes:

• The AVERAGE() function ignores cells with text or errors.
• The AVERAGE() function supports up to 255 arguments.

In summary, the AVERAGE() function is a useful tool for calculating the average of a set of numbers in Microsoft Excel.

### Refer to more FAQs to learn the AVERAGE function in MS Excel

How to use the AVERAGE function?

The AVERAGE function in Microsoft Excel can be used to calculate the average of a set of numbers. The syntax for the formula is `=AVERAGE(number1, [number2], ...)`, where `number1` is the first number in the set and `[number2]` are additional numbers in the set (up to a total of 255). The numbers can be entered directly into the formula or as cell references to the location where the numbers are stored.

How to calculate the average of a range of cells?

To calculate the average of a range of cells, specify the cell range in the AVERAGE formula. For example, if you have a set of numbers in cells A1 to A5, you could use the following formula to find the average: `=AVERAGE(A1:A5)`.

How to ignore blank cells when calculating the average?

By default, the AVERAGE function will ignore any blank cells within the specified range. If you have a cell with text or an error value in the range, the AVERAGE formula will return an error.

How to calculate the average of only certain values in a range?

To calculate the average of only certain values in a range, you can use a combination of the AVERAGE function and the IF function. The IF function can be used to determine which values in the range should be included in the calculation and which should be ignored.

#### esyExcel

Gavesh S. is the founder and owner of EsyExcel.com. He has been a Microsoft Excel Expert since early 2012. With experience explained thousand of queries for companies including Microsoft and top other financial institutions. Theres is most uses of Business Analysis, People Management, Automation, Performance Reporting, Strategic Analysis, Project Management, Managing Programs, Account Management etc.  In 2021 he found EsyExcel.com to share his experiences with other who’s is looking to learn MS Excel. He is currently working on a book about working in the Learn Excel, expanding his skill set beyond the Excel Learning niche.