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.











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


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

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.