How to Use AVERAGE Function in Excel | Excel Formula Guide

Learn how to use the AVERAGE function in Excel to calculate mean values. Step-by-step guide with syntax, examples, and tips for accurate data analysis.

Download PDF

Average function

• Returns the average (arithmetic mean) of the arguments.

For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers.

• Video Tutorial: Use of AVERAGE() function in excel

See also:

• AVERAGE function - Excel Exercises
• AVERAGE function - Microsoft Support

Exercise 2:

• Create a new Excel worksheet.
• In cells A1 to A10, enter the following numbers: 10, 20, 30, 40, 50, 60, 70, 80, 90, and 100.
• In cell A11, enter the following formula: =AVERAGE(A1:A10)
• Press Enter.

The result, 55, should appear in cell A11.

Exercise 1: Calculate the average of the following numbers:

1, 2, 3, 4, 5

Exercise : Calculate the average of the numbers in the following range:

A1:A10

Exercise : Calculate the average of the numbers in the following range, excluding the first and last numbers:

A1:A10

Exercise 2: Calculate the average per month sales of the year, using the following data:

Exercise 3: Calculate the average of the sales figures for all customers who have spent more than $1000, using the following data:

Exercise : Calculate the average of the positive numbers in the following range:

A1:A10