How to Use AVERAGE Function in Excel: Simple Guide

Use the AVERAGE function in Excel to find the mean of numbers by typing =AVERAGE(range) where range is the cells you want to average. It adds all numbers in the range and divides by the count of numbers automatically.

Syntax

The AVERAGE function calculates the mean of numbers in a range or list of values.

• AVERAGE(number1, [number2], ...)
• number1, number2, ... are numbers or cell references you want to average.
• You can use a range like A1:A5 or individual numbers separated by commas.

excel

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

Example

This example shows how to average numbers in cells A1 to A5.

excel

=AVERAGE(A1:A5)

Output

If A1=10, A2=20, A3=30, A4=40, A5=50, the result is 30

Common Pitfalls

• Including empty cells or text in the range does not affect the average because Excel ignores them.
• Using cells with zero values counts as zero in the average, which lowers the result.
• Typing numbers as text will cause Excel to ignore them in the average.

excel

=AVERAGE(A1:A5)  
Wrong: If some cells have text like "ten", they are ignored.
Right: Make sure all numbers are numeric values.

Quick Reference

Function	Description	Example
AVERAGE	Calculates mean of numbers	=AVERAGE(A1:A5)
AVERAGEA	Includes text and logical values	=AVERAGEA(A1:A5)
AVERAGEIF	Average with condition	=AVERAGEIF(A1:A10, ">10")

Key Takeaways

Use =AVERAGE(range) to quickly find the mean of numbers in Excel.

Empty cells and text are ignored in the AVERAGE calculation.

Ensure numbers are numeric, not text, for accurate results.

Zero values count as zero and affect the average.

Use related functions like AVERAGEIF for conditional averages.