How to Use AVERAGE Function in Google Sheets Easily

Use the AVERAGE function in Google Sheets by typing =AVERAGE(range), where range is the cells you want to average. It calculates the mean of the numbers in the selected cells automatically.

Syntax

The AVERAGE function calculates the average (mean) of numbers in a range or list of cells.

• value1, value2, ...: One or more numbers or ranges to average.

Example: =AVERAGE(A1:A5) calculates the average of values in cells A1 through A5.

plaintext

=AVERAGE(value1, [value2, ...])

Example

This example shows how to calculate the average of numbers in cells A1 to A5.

plaintext

A1: 10
A2: 20
A3: 30
A4: 40
A5: 50

In cell B1, enter:
=AVERAGE(A1:A5)

Output

30

Common Pitfalls

Common mistakes when using AVERAGE include:

• Including empty cells or text cells that are ignored, which can affect your expected result.
• Using commas instead of colons for ranges (e.g., A1,A5 instead of A1:A5).
• Trying to average cells with errors, which causes the function to return an error.

Correct usage example:

=AVERAGE(A1:A5)

Incorrect usage example:

=AVERAGE(A1,A5) (this averages only two cells, not the range)

Quick Reference

Function	Description	Example
AVERAGE	Calculates the mean of numbers in a range	=AVERAGE(A1:A10)
AVERAGEIF	Calculates average with a condition	=AVERAGEIF(A1:A10, ">20")
AVERAGEA	Includes text and logical values in average	=AVERAGEA(A1:A10)

Key Takeaways

Use =AVERAGE(range) to find the mean of numbers in selected cells.

Ensure your range uses a colon (:) to include all cells between start and end.

Empty or text cells are ignored by AVERAGE, but error cells cause errors.

Use AVERAGEIF to average only cells that meet a condition.

Double-check your ranges to avoid averaging unintended cells.