AVERAGE Formula — Calculate Mean in Excel & Sheets | SheetMaster

Returns the average (arithmetic mean) of the arguments.

Generated Formula
=AVERAGE(range)

Learning Resources

Want to master Excel? Check out this Top-Rated Course.

Common Errors & Fixes

  • #DIV/0! error

    Causes:
    • The range contains no numeric values — all blank cells, text, or errors.
    • The range reference is invalid.
    Fixes:
    • Add at least one number to the range.
    • Use IFERROR to handle the error gracefully: =IFERROR(AVERAGE(A1:A10), 0).

Frequently Asked Questions

What is the difference between AVERAGE and MEDIAN?

AVERAGE calculates the arithmetic mean (sum divided by count). MEDIAN returns the middle value. MEDIAN is better for data with outliers.

How does AVERAGE handle blank cells and zeros?

AVERAGE ignores blank cells but counts zeros. This means a cell with 0 lowers the average. Use AVERAGEA to count text as 0.

Does AVERAGE work in Google Sheets?

Yes, AVERAGE works identically in Google Sheets with the same syntax.

Related Formulas

Explore related formula generators to solve similar problems

SUMIFCOUNTIFPMTSUMIFSCOUNTIFS

🛠️ Related Tools

Formula Comparator

Compare Excel formulas side by side

Remove Duplicates

Clean duplicate values from your data

GPA Calculator

Weighted & unweighted grade point average

SUMIFS Across Sheets

Sum across multiple Excel sheets

Want to become an Excel Pro?

Stop searching for formulas. Master Excel in 30 days with this top-rated course.

Learn More