How to Find an Average in Excel With AVERAGE Function

To find the average in Excel, enter the AVERAGE function in an empty cell and point it to the numbers you want to include. If your values are in cells B2 through B6, use =AVERAGE(B2:B6); for 72, 85, 90, 68, and 85, the result is 80 because their total is 400 and 400 divided by 5 is 80. You can also use Excel’s AutoSum menu or check the average on the status bar for a quick one-time result.

What You’ll Need

A workbook open in Microsoft Excel for Microsoft 365 on Windows. The basic steps are similar in Excel for Mac and Excel for the web, though ribbon placement can vary slightly.
A range of numeric values to average. Ideally, put the values in one column or row, with a descriptive heading kept outside the range.
An empty cell for the result if you want the average to remain in the worksheet. You can also select cells and read the average from the status bar without adding a formula.

Step-by-Step

Arrange and check the values. Put the measurements, scores, prices, or other numbers in a continuous range when possible. For example, place a heading in B1 and the five example values 72, 85, 90, 68, and 85 in B2:B6. Keep labels such as names or dates in a separate column. A clear layout makes it easier to select the right cells and check your result.
Choose where the answer should appear. Click a blank cell that is not inside the data range, such as B7. If you put the formula in one of the cells being averaged, you can create a circular reference or accidentally replace one of your source values. Choosing a cell below the data also makes the result easy to find.
Enter the AVERAGE formula. With the example values in B2:B6 and the result cell B7 selected, type =AVERAGE(B2:B6) and press Enter. The colon means include every cell from B2 through B6. Excel returns 80: the five values add to 400, and 400 divided by five values is 80. The function calculates the arithmetic mean, not the middle value or the most frequent value.
Select a range by pointing instead of typing. Click the result cell, type =AVERAGE(, then drag over the cells you want to include. Excel inserts the selected address. Type the closing parenthesis and press Enter. This approach can help avoid mistyping a row or column reference, particularly in a large sheet. Check that the highlighted range excludes headings and unrelated numbers before you confirm it.
Use AutoSum if you prefer the ribbon. Select an empty cell beneath or beside your numbers. On the Home tab, in the Editing group, open the AutoSum dropdown and choose Average. Excel proposes a range; inspect the selection and adjust it if necessary, then press Enter. AutoSum is a shortcut for creating a formula, so the result updates when the referenced numbers change. If the proposed range is wrong, select the intended cells before confirming.
Check an average without adding a formula. Select the numeric cells and look at Excel’s status bar at the bottom of the window. If Average is shown, you can read the result there. If it is not visible, right-click the status bar and select Average in the list. This is useful for a quick check, but it does not put a lasting result in a worksheet cell. On Mac, the status bar can also be customized by right-clicking or Control-clicking it.
Confirm the result and keep it readable. Compare the answer with the values: an ordinary average of numeric values should fall between the smallest and largest included numbers. If appropriate, format the result as a number with a suitable number of decimal places using Home > Number. Changing the display format rounds what you see, not the underlying calculation. Leave enough decimal places when precision matters.

For a non-adjacent selection, you can include more than one range by separating the ranges with commas. For example, if the first set of scores is in B2:B4 and a second set is in D2:D4, the layout assumes those two ranges contain the only scores to include. The formula =AVERAGE(B2:B4,D2:D4) averages all six numeric cells together. If the values are 70, 80, 90, 60, 80, and 100, Excel returns 80: the sum is 480 and 480 divided by 6 is 80. Check that combining the groups is appropriate before using this method.

If you need the average for rows that meet a condition, use AVERAGEIF. For example, assume A2:A5 contains East, West, East, East and B2:B5 contains 80, 100, 90, 70. The formula =AVERAGEIF(A2:A5,"East",B2:B5) returns 80, because it averages 80, 90, and 70, whose total of 240 divided by 3 is 80. The first range contains the labels to check, East is the condition, and the last range contains the numbers to average. For a basic overall average, AVERAGE is simpler.

Common Mistakes

Including a heading or unrelated cell. AVERAGE ignores text in referenced cells, so a heading may not change the result, but selecting extra numeric cells can. Check the range shown in the formula bar and confirm its first and last cells.
Assuming blank cells count as zero. AVERAGE ignores genuinely empty cells. If three cells contain 10, 20, and 30 and a fourth is blank, the average is 20, not 15. If a missing value should count as zero for your analysis, enter a numeric 0 deliberately.
Forgetting that zero is a value. A zero in the selected range is included in both the sum and the count. Values 10, 20, and 0 average 10. Do not delete or exclude zeros just because they lower the result; first decide whether they represent real observations.
Using numbers stored as text. A cell may look like a number but be stored as text, especially after copying data from a website or another system. AVERAGE generally ignores text in a referenced range, which can make the result unexpectedly high or low. Check cell alignment, warnings, or the Number Format, and convert genuine numeric text to numbers before calculating.
Expecting hidden rows to be omitted. AVERAGE includes values in rows hidden by filtering or manually hidden. If you want an average of only visible records, use a method designed for visible cells rather than assuming the ordinary AVERAGE formula changes with the display.

Tips

Use a range reference such as B2:B100 instead of typing a list of numbers into the function. This keeps the calculation connected to the source data and makes later edits easier to audit.
Keep headings in a separate row and use consistent data types in each column. A column intended for test scores should not mix scores with notes such as absent or pending; record those statuses separately.
For a growing list, you can make the data an Excel table with Insert > Table. AVERAGE formulas that refer to table columns can be easier to read and maintain as rows are added. Confirm that the formula includes the intended table data.
Use the status bar as a quick independent check after entering a formula. Select the same numeric cells and compare its displayed average with the worksheet result; a mismatch is a clue that the formula references a different range or that some values are text.
Keep the underlying precision unless there is a reason to round the calculation. Applying a number format to show two decimal places changes the display only. If a later calculation uses the average, Excel can still use its full stored value.
Choose the right kind of average for the question. AVERAGE gives each included number equal weight. If some observations should count more than others, a simple arithmetic average may not describe the intended result; confirm the appropriate method before reporting it.

Troubleshooting

The formula displays an error. Check that the function name is spelled AVERAGE, that the opening and closing parentheses are present, and that the referenced cells exist. If Excel shows a formula error after you enter it, click the formula cell and inspect the reference for a typo. The formulas in this guide use commas between separate arguments, as in the standard English-language Microsoft 365 setup. Some regional settings use semicolons as argument separators; if Excel rejects a formula with commas, use the separator configured for your installation.

The result is higher or lower than expected. Select the formula cell and inspect the range between the parentheses. Make sure it does not omit the first or last observation, include a total row, or include another column of numbers. Then check whether number-looking cells are stored as text. A quick diagnostic is to select the suspected values and see whether Excel’s status bar reports a count and average consistent with the numeric entries. Convert only cells that are intended to be numbers.

Excel returns #DIV/0!. This usually means there are no numeric values in the referenced range. Confirm that you selected the cells containing the data, not just a heading or blank cells, and check whether the apparent numbers are stored as text. If the source is intentionally empty, wait to calculate the average until numeric observations are available rather than treating the error as a meaningful average.

The answer changes after filtering the list. That is expected with AVERAGE: filtering changes which rows are displayed but does not remove hidden values from its calculation. If the required result is specifically the average of visible rows, use Excel’s SUBTOTAL function with the average operation, and choose the option that matches whether manually hidden rows should also be excluded. Check the result after applying and clearing the filter so you know which rows the calculation includes.

The status bar does not show Average. Select at least one numeric cell, then right-click the status bar and enable Average. If the selection contains only text or blanks, Excel may have no numeric average to display. For a result you need to preserve, use a worksheet formula instead of relying on the status bar.

Frequently Asked Questions

What is the difference between AVERAGE and MEDIAN?
AVERAGE adds the included numeric values and divides by their count. MEDIAN returns the middle value after the values are ordered. A very high or low observation can shift an average more than it shifts a median, so they answer different questions.

Does AVERAGE count blank cells?
No. AVERAGE ignores blank cells in a referenced range, as well as text entries in that range. It does count numeric zeros. Decide whether missing observations should be left blank or represented by zero before interpreting the result.

Can I average cells that are not next to each other?
Yes. Enter multiple cell ranges as arguments, separated by commas, and confirm that each selected range belongs in the same calculation. If the groups represent different populations or have different importance, combining them may not be meaningful even though Excel can calculate the result.

How do I average only values that meet a condition?
Use AVERAGEIF when one condition determines which values to include, such as averaging scores for one location. Put the category or condition range first and the numeric range to average last. For more than one condition, Excel also has AVERAGEIFS, which lets you specify multiple criteria.

Why does my average show too many decimal places?
The result may be more precise than the display you want. Select the result cell and use the decimal-place controls in Home > Number, or open Format Cells to choose a number format. Display formatting does not change the underlying average; use rounding only when the calculation itself must be rounded.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.