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