How to Use AVERAGE in Google Sheets
=AVERAGE(value1, [value2, ...]).
What AVERAGE does
AVERAGE adds up the values and divides by how many there are. You can give it one range, several ranges, single numbers, or a mix of all three.
AVERAGE syntax
=AVERAGE(value1, [value2, ...])
value1: the first value or range to include.value2, ...(optional): more values or ranges.
Per Google's help page, text in the arguments is ignored. To count text as 0, use AVERAGEA instead. For the middle value rather than the mean, use MEDIAN.
A step-by-step example
Here are five test scores in cells A1:B6.
| A | B | |
|---|---|---|
| 1 | Name | Score |
| 2 | Ann | 82 |
| 3 | Ben | 64 |
| 4 | Cara | 91 |
| 5 | Dev | 77 |
| 6 | Eli | 58 |
To find the average score:
=AVERAGE(B2:B6)
This returns 74.4. Here is why:
- The scores add up to 82 + 64 + 91 + 77 + 58 = 372.
- There are five of them, and 372 / 5 = 74.4.
Mix a range with single numbers
Arguments can be combined. Google's own examples include AVERAGE(1,2,3,4,5,C6:C20). To average the first three scores together with a fixed value of 100:
=AVERAGE(B2:B4, 100)
This returns 84.25, which is (82 + 64 + 91 + 100) / 4.
Common AVERAGE mistakes
- Numbers stored as text. They are ignored, which changes the result without an error. Check that your numbers are right-aligned.
- Expecting text to count as zero. AVERAGE skips it. Use AVERAGEA if you want it counted as 0.
- Averaging only some rows. To average rows that meet a condition, use AVERAGEIF.
- Confusing mean and median. One very large value pulls the mean up. MEDIAN is steadier.
Try it yourself
Use the score table above (A1:B6). Type your formula into the box, starting with =, then press Check.
Exercise 1: Average score
Write a formula that returns the average of all the scores in B2:B6.
Exercise 2: Range plus a number
Write a formula that averages the scores in B2:B4 together with the single number 100.
What to learn next
- AVERAGEIF: average the values that meet a condition.
- MIN and MAX: find the smallest and largest values.
- LARGE and SMALL: find the nth largest or smallest value.
- COUNT and COUNTA: count numbers or non-empty cells.
- MEDIAN: find the middle value of a range.
- MEDIAN: the middle value of a range.
Syntax and rules in this guide were checked against Google's AVERAGE help page. See all guides.