The AVERAGE function does the math for you

To find the average of a group of numbers in Excel, use the AVERAGE function. Type =AVERAGE(, then select the cells containing your numbers, then close with ). Excel adds them up and divides by how many numbers there are — all in one step.

For example, if your numbers sit in cells A1 through A5, you would type =AVERAGE(A1:A5) and press Enter. The cell shows the result. You do not have to add them yourself or count how many there are. The function handles both.

This works whether your numbers are in a column, a row, or scattered across the sheet. You can also average numbers from different ranges at once by separating them with commas: =AVERAGE(A1:A5,C1:C5) will average all ten numbers together.

Key Takeaways

  • The AVERAGE function adds numbers and divides by the count in one formula: =AVERAGE(A1:A5).
  • You can average a range (A1:A5), multiple ranges (A1:A5,C1:C5), or individual cells (A1,A3,A7).
  • AVERAGEIF lets you average only cells that meet a condition, such as values greater than 10 or text matching a name.
  • AVERAGEA includes text and logical values in the count, while AVERAGE ignores them — use AVERAGE for numbers only.

Selecting the range of cells to average

The most common way to use AVERAGE is to select a continuous block of cells. Click on the first cell, hold Shift, and click on the last cell. Excel highlights the range and shows it in your formula as A1:A5 (or whatever your first and last cells are).

You can also type the range directly. If you know your numbers are in A1 through A10, just type =AVERAGE(A1:A10) without clicking. This is faster once you know where your data sits.

If your numbers are not next to each other, separate each range or cell with a comma. For instance, =AVERAGE(A1:A5,A10:A15) averages two separate blocks. Or =AVERAGE(A1,A3,A7) averages just those three individual cells.

Using AVERAGEIF to average only certain numbers

Sometimes you want to average only the numbers that meet a condition. The AVERAGEIF function does this. The formula is =AVERAGEIF(range, criteria, average_range).

For example, if column A holds sales amounts and column B holds the salesperson's name, you could average only the sales for one person: =AVERAGEIF(B:B,"Sarah",A:A). This tells Excel to look at column B, find every cell that says "Sarah", and average the numbers in column A on those same rows.

You can also use comparison operators. =AVERAGEIF(A:A,">100") averages only numbers greater than 100. =AVERAGEIF(A:A,"<50") averages only numbers less than 50. The criteria goes in quotes, and Excel checks every cell in the range against it.

Averaging with multiple conditions using AVERAGEIFS

If you need to match more than one condition at once, use AVERAGEIFS instead. The formula is =AVERAGEIFS(average_range, criteria_range1, criteria1, criteria_range2, criteria2).

Suppose column A holds sales amounts, column B holds the salesperson's name, and column C holds the month. To average sales for Sarah in January only, you would type =AVERAGEIFS(A:A,B:B,"Sarah",C:C,"January"). Excel finds rows where column B is "Sarah" AND column C is "January", then averages the numbers in column A from those rows.

You can add as many conditions as you need. Each condition is a pair: a range to check and the criteria it must match. All conditions must be true for a row to be included in the average.

The difference between AVERAGE and AVERAGEA

The AVERAGE function ignores text, empty cells, and TRUE/FALSE values. It counts only actual numbers. If you have a mix of numbers and text in the same range, AVERAGE skips the text and averages only the numbers.

The AVERAGEA function treats text and logical values differently. Text counts as zero, and TRUE counts as 1 and FALSE counts as 0. This changes the average. For most everyday use, AVERAGE is what you want — it averages numbers and leaves everything else alone.

Use AVERAGEA only if you have a specific reason to include text or TRUE/FALSE values in your calculation. In most cases, if your data has text mixed in, you should clean it out or use AVERAGEIF to select only the number cells.

Common mistakes and how to fix them

One frequent error is forgetting the colon in a range. =AVERAGE(A1 A5) does not work — it must be =AVERAGE(A1:A5) with a colon between the first and last cell. Excel shows an error if you leave it out.

Another mistake is including a header row by accident. If row 1 contains the label "Sales" and your numbers start in A2, use =AVERAGE(A2:A10), not =AVERAGE(A1:A10). The text in A1 will not break the formula, but it adds confusion and makes the result harder to trust.

If your formula returns an error like #DIV/0!, it usually means the range contains no numbers at all — only text or empty cells. Check that your range actually contains the data you think it does. If the range is correct but contains mostly text, switch to AVERAGEIF to select only the number cells.

Frequently Asked Questions

Can I average cells that are not next to each other?

Yes. Separate each range or cell with a comma: =AVERAGE(A1:A5,C1:C5,E2) averages two ranges and one individual cell. Excel adds all the numbers and divides by the total count, regardless of where they sit on the sheet.

What happens if I include empty cells in my range?

AVERAGE ignores empty cells. If you average A1:A10 and three of those cells are blank, Excel counts only the seven cells with numbers. This is usually what you want, but it means the average is not affected by the blanks.

How do I average only positive numbers or only negative numbers?

Use AVERAGEIF with a comparison operator. =AVERAGEIF(A:A,">0") averages only positive numbers. =AVERAGEIF(A:A,"<0") averages only negative numbers. The criteria goes in quotes, and Excel checks each cell against it.

Can I average numbers from a different sheet?

Yes. Include the sheet name in your range: =AVERAGE(Sheet2!A1:A10). Replace "Sheet2" with the actual name of the sheet, and use an exclamation mark to separate the sheet name from the cell range.

What is the difference between AVERAGE and SUM?

AVERAGE adds numbers and divides by the count, giving you the middle value. SUM just adds them without dividing. Use AVERAGE when you want to know the typical value, and SUM when you want the total.