How to Calculate Average in Google Sheets | Scribe
This guide was created with Scribe in 48 seconds. Sign in and create your own!
How to Calculate Average in Google Sheets
Alejandra Arciniegas |
0 step |
48 seconds
Google Sheets
The first thing you have to do, is to navigate to Google Sheets.
Once you open you spreadsheet document, click on the cell you want the average to appear.
Zoom Saved
Then, type "=average("
Now, you can either type the name of the first cell you want for the average or click on it. You can add a comma to separate it from the next one.
Zoom Saved
Then, you can either type the name of the next cell, or click on it. So on and so forth.
Zoom Saved
Once you have all the information, hit "enter" and you'll get the average.
If you want to calculate the average of multiple values of a column, you can type "=average(", and select the cell where de data starts.
Zoom Saved
Then, instead of a comma, type ":".
You can type the last cell of the group, or you can just click on the option that Google Sheets will show you below. And that's all!
Zoom Saved
Documents you might like
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe
Have something to say?Create an account to leave messages for the author to see!
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key