Average Function

The AVERAGE Function is a quick and easy way of finding the average of a set of figures in Sheets.

What it does…

Averages a range of cells.

Syntax

=AVERAGE(cellref:cellref)

=AVERAGE(1,2,3,4,5)

=AVERAGE(1,2,cellref:cellref)

=AVERAGE(cellref:cellref,cellref:cellref)

Examples

=AVERAGE(A1:A10)

=AVERAGE(1,2,A2:A12)

=AVERAGE(B2:B8,C2:C8,D2:D8)

Instructions

To use the AVERAGE function in Sheets,

  1. Click on the cell where you want your answer

  2. Click on the Functions icon (the Greek letter sigma – looks like a backwards E)

  3. Choose AVERAGE

  4. Click and drag over the cells you want to average

Shortcut

In Sheets, you can highlight the cells you want to total, then in the bottom right-hand corner of your screen find Sum: total (next to Explore Explore) To see more calculations, click on Sum (next to Explore). Then choose AVERAGE.

Sheets Average Function
Download the Example

Click on the download button above, if you want to download a copy of the example used on this page into your Sheets account.

Other useful functions in Sheets include MAX, MIN and SUM. To return to the resources page, just click here.