How to Use AVERAGE in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: AVERAGE returns the mean of the numbers you give it: the sum divided by how many values there are. The formula is =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, ...])

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.

AB
1NameScore
2Ann82
3Ben64
4Cara91
5Dev77
6Eli58

To find the average score:

=AVERAGE(B2:B6)

This returns 74.4. Here is why:

  1. The scores add up to 82 + 64 + 91 + 77 + 58 = 372.
  2. 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

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.

Hint: one range argument.

Exercise 2: Range plus a number

Write a formula that averages the scores in B2:B4 together with the single number 100.

Hint: separate the range and the number with a comma.

What to learn next

Syntax and rules in this guide were checked against Google's AVERAGE help page. See all guides.