Excel's Average Function for Calculating the Mean

Buzz

Ngày cập nhật gần nhất: 15/4/2026

Content

Description

Syntax

Note

Example

The Average function in Excel helps you calculate the average value for a range of numbers, an array, or a reference containing numbers quickly and accurately. You won't have to spend time performing each calculation to calculate the average, just use the Average function directly.

This article describes the syntax and usage of the Average function in Excel.

Description

The Average function returns the average of the input arguments (also known as the result of dividing the sum of the values of the input arguments by the total number of arguments). The input values are numbers or ranges, references to cells containing numbers.

In addition, you can use the following functions:

AVERAGEA Function: returns the average value of all values in a column, handling text values and non-numbers.

AVERAGEIF or AVERAGEIFS Function: if you only want to calculate the average of values that meet certain conditions, specific criteria.

Syntax

=AVERAGE(number1,[number2],…)

Where:

- number1: the first argument can be a number, a cell reference, or a range containing numbers that you want to average, required.

- number2: are numbers, cell references, or ranges containing additional numbers that you want to average up to 255 numbers, optional.

Note

- Cell reference or range argument containing logical values, text, or empty cells will be ignored, except for the value 0 which will be counted.

- Logical values, text representing numbers that you directly enter into the list of arguments in the function will be counted.

- If the argument is text or a value that cannot be converted to a number, an error will occur.

Example

For the data table:

1. Calculate the average of the numbers from B5 to B8.

Applying the function: =AVERAGE(B5:B8) we get the result:

2. Calculate the average of the numbers from D5 to D8 and the number 10.

Applying the function: =AVERAGE(D5:D8,10) we get the following result:

3. Calculate the average of the numbers from B5 to E8.

Applying the function: =AVERAGE(B5:E8) we get the result:

The article has guided how to use the Average function to calculate the average value, this is a quite popular function and widely used in Excel calculations that you should know. Wish you success!

Frequently Asked Questions

What is the primary purpose of the Average function in Excel?

The primary purpose of the Average function in Excel is to quickly calculate the average value of a range of numbers or arrays. This function simplifies data analysis by eliminating the need for manual calculations, thus enhancing efficiency and accuracy in handling numerical data.

What are the required and optional parameters for the Average function?

The Average function requires at least one argument, 'number1', which can be a number, cell reference, or range. Additionally, up to 255 optional arguments ('number2') can be provided to include more values in the average calculation, allowing flexibility in data analysis.

How does the AVERAGEIF function differ from the standard Average function?

The AVERAGEIF function differs from the standard Average function by allowing users to calculate averages based on specific conditions or criteria. This targeted approach enables more precise analysis, particularly when dealing with large data sets with varying values.

Can logical values and text be included in the Average function calculations?

Yes, logical values and text that represent numbers can be included in the Average function calculations, but logical values, text, or empty cells in cell references will be ignored. Only numerical values and specific entries are considered for averaging.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]