AVERAGE
How to calculate the average in Excel (AVERAGE, MIN, MAX)
AVERAGE returns the arithmetic mean of numbers, while MIN and MAX return the smallest and largest value.
Syntax
=AVERAGE(number1, [number2], ...)
- number1, ... — The numbers or range to average.
Example
Formula:
=AVERAGE(B2:B4)→ result: 78.33
AVERAGE
Divides the sum of the numbers in a range by how many there are. Empty cells are ignored, but cells containing 0 are counted.
MIN and MAX
=MIN(B2:B10) returns the smallest number and =MAX(B2:B10) the largest. Use them for rankings, finding top sales or the lowest price.
Average with a condition
To average only the values that meet a condition, use AVERAGEIF: =AVERAGEIF(B2:B10,">60").
Put it into practice
Do interactive exercises on this topic in the Excel simulator.
Start exerciseFrequently asked questions
The range contains no numbers. Check the range or use =IFERROR(AVERAGE(B2:B10),0).
Yes: =ROUND(AVERAGE(B2:B10),1) rounds the result to one decimal place.