Calculate an Average

Use AVERAGE to find the typical value in a list of numbers.

You will learn to

• Use AVERAGE on a range
• Know that AVERAGE ignores empty cells and text

How it works

AVERAGE adds the numbers in a range and divides by how many numbers there are. =AVERAGE(B2:B7) is the same as =SUM(B2:B7)/COUNT(B2:B7). Empty cells and text are ignored, but zeros are included.

=AVERAGE(B2:B7)