AVERAGE Function

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.

AVERAGE is useful because many worksheet questions are not about totals but about the typical value in a set. It gives the workbook a quick center point for performance, pricing, measurement, and many other data summaries where the mean matters more than the sum.

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 standard way most people use AVERAGE. You point to a block of numeric cells, and Excel adds them together and divides by how many numbers are in the range.

The result gives you one typical value for the group. In a sales example, that can help you describe what a normal month looks like instead of reading each month one by one.

=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 worksheet cells for every quick check. This example shows that you can type the numbers directly into the formula when you only need a simple one-off calculation.

That makes it useful for learning, quick testing, or checking a small set of values before you build a full table.

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

Example 3 - Mix a range with one extra number

This example is useful for a quick what-if question. You can keep the existing range as it is, then add one extra number to see how that new value would affect the overall average.

That matters because the extra number becomes part of both the total and the count. It is a small example, but it shows how easy it is to test a scenario without changing the source data.

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

Example 4 - Average a larger range

When the range gets larger, the result represents more of the full dataset instead of just a small sample. That usually makes the average more useful for summaries and reporting.

This is a good reminder that the size of the range changes the meaning of the result. A small range may describe one short period, while a larger range may describe the broader trend.

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

Conclusion Recap

AVERAGE is the basic function to use when you want one number that represents a group of numbers. In this lesson, that included normal cell ranges, typed values, and even a mix of both in one formula.

The main thing to remember is simple: Excel adds the numeric values, divides by how many numbers are included, and ignores blank cells and text in ranges. That makes AVERAGE a good starting point when you want a quick summary of sales, scores, or any other numeric list.

• 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.