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,
- Click on the cell where you want your answer
- Click on the Functions icon (the Greek letter sigma – looks like a backwards E)
- Choose AVERAGE
- 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 ) To see more calculations, click on Sum (next to Explore). Then choose AVERAGE.
Click on the download button above, if you want to download a copy of the example used on this page into your Sheets account.