Google Sheets function
AVERAGE function in Google Sheets
AVERAGE in Google Sheets returns the numerical mean of values and ranges while ignoring text. It adds the numeric values, then divides by how many numeric values were included. Use it for marks, response times, prices, or any dataset where the arithmetic mean answers the question.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=AVERAGE(value1, [value2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
value1 | Yes | The first value or range to include in the mean. |
value2, ... | No | Additional values or ranges to include. |
Examples
Average three scores
| A | B | |
|---|---|---|
| 1 | Student | Score |
| 2 | Ava | 84 |
| 3 | Ben | 92 |
| 4 | Cara | 88 |
=AVERAGE(B2:B4)Result: 88
The three scores total 264, and 264 divided by 3 is 88.
Common mistakes
Expecting text in the range to count as zero.
AVERAGE ignores text. Use AVERAGEA when text should be treated as zero.
Dividing a SUM by a typed row count.
Use AVERAGE so the count follows the numeric values in the range.