Summary

AVERAGE returns the arithmetic mean of a set of numbers. It adds the numbers together and divides the total by how many numeric values are included, so you get one result that represents the group.

This is one of the most useful summary functions in Excel because it helps you turn a long list into something easy to read. If you want the typical sales amount, the usual score, or the general level of a metric, AVERAGE is often the first place to start.

Syntax

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

You can use one range, several cells, typed numbers, or a mix of them. Excel allows up to 255 arguments in the function.

Arguments

• number1 - [required] The first number, cell reference, or range you want to average.
• number2, ... - [optional] More numbers, references, or ranges to include.

AVERAGE vs Other Functions

AVERAGE is the standard choice when you want the mean, but it is not the only way to summarize the center of a list.

Using the AVERAGE Function

AVERAGE works best when you want a clean summary of numeric data. In a sales sheet, it can show the usual daily revenue. In a grade sheet, it can show a student's overall result. In a dashboard, it helps reduce a long column of numbers into one quick reading.

There are a few rules worth knowing because they affect the result. Microsoft notes that numbers in references are counted, empty cells are ignored, and cells containing zero are included. If a referenced range contains text or logical values, those are ignored by AVERAGE. If you type a logical value or text form of a number directly into the argument list, AVERAGE still does not count it. If you need those kinds of values included, AVERAGEA is the better fit.

• Use it for ranges like A1:A10 when your data is already in cells.
• Use it with typed values when you want a quick check, like =AVERAGE(10,20,30).
• Be careful with outliers because one unusually large or small number can pull the mean.

Example 1 - Average a range of sales values

This is the usual pattern. You select a block of numeric cells and let Excel calculate the mean.

=AVERAGE(B1:B5) // Returns the average of the values in B1 through B5.

Example 2 - Average numbers typed in the formula

You do not need a range for every case. AVERAGE also works with numbers typed directly into the formula.

=AVERAGE(10,20,30) // Returns 20.

Example 3 - Mix a range with one extra number

This is useful for quick what-if checks. You can average existing data and add another value without changing the worksheet itself.

=AVERAGE(B1:B5,100) // Adds 100 into the average with the range.

Example 4 - Average a larger range

When you expand the range, the result reflects more of the full dataset instead of just a small sample.

=AVERAGE(B1:B10) // Returns the average for the full range.

Conclusion Recap

• Main job: AVERAGE returns the arithmetic mean of numbers.
• Flexible input: You can use ranges, cell references, typed numbers, or a mix.
• Blanks and text in ranges: They are ignored.
• Zero counts: A cell with 0 is still part of the average.
• Empty result warning: If Excel finds no numeric values to average, you get #DIV/0!.
• Related option: Use AVERAGEA if you need logical values or text numbers in references included.