AVERAGE Function
Calculates the mean of the provided numbers.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| number1 | The first number, range, or cell reference. | Required |
| number2 | Additional numbers, ranges, or cell references (optional). | Optional |
Basic Example
Average of test scores
=AVERAGE(A2:A10)Adds all values in A2:A10 and divides by the count of numeric values.
Advanced Examples
Example 1: Average with multiple ranges
Quarterly salesAverage two separate ranges
=AVERAGE(B2:B10, D2:D10)Example 2: Average excluding blanks
Survey dataAVERAGE ignores empty cells and text automatically
=AVERAGE(A2:A100)How AVERAGE Works
AVERAGE sums the numeric values and divides by the count of numeric values. It ignores text, logical values, and empty cells.
Important Notes & Limitations
Ignores text and empty cells, which may affect the denominator count.
Does not ignore zero values.
Cells with logical TRUE/FALSE are ignored.
Common Errors & Fixes
#DIV/0! errorNo numeric values in the range.Fix: Ensure the range contains at least one number.
Wrong averageText-formatted numbers are treated as text.Fix: Convert text to numbers first.
Download Practice File
AVERAGE
averagePractice AVERAGE with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the AVERAGE function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps
Related Tutorials
AVERAGEIF with Criteria
Learn how to use AVERAGEIF with criteria in Excel and Google Sheets: syntax, text, number and date conditions, wildcards, and when to switch to AVERAGEIFS.
AVERAGEIFS Multiple Criteria
AVERAGEIFS multiple criteria lets you average cells that satisfy two or more conditions at once. Learn the syntax, real examples, and how it differs from AVERAGEIF and SUMIFS.
Excel Budget Template
Build an Excel budget template from scratch: structure your sheets, total spending by category with SUMIF, flag overspending with IF, and track averages.
Excel Functions vs Formulas
Excel functions vs formulas: learn the difference. A formula is the calculation you write; a function is a built-in tool like SUM, AVERAGE or IF that powers it.
How to Use Excel Formulas: From the First Equals Sign to a Real Report
Learn how to use Excel formulas step by step: the equals sign, cell references, SUM, IF and VLOOKUP, plus the errors beginners hit and how to fix them.
Median vs Average
Median vs average is the classic statistical showdown: median resists outliers, average reacts to them. Learn when to use each in Excel and Google Sheets.
Standard Deviation in Excel: STDEV vs STDEVP
Standard deviation Excel formulas are not all the same. See when to use STDEV vs STDEVP, how the n-1 divisor works, and how to read the result correctly.
What Is a Formula in Excel
What is a formula in Excel? Learn how formulas differ from functions, how cell references and operators work, and build a calculation with SUM, AVERAGE, and IF.