# How To Calculate Average in Google Sheets

If you need to calculate the average of a set of numbers, then you can use Google Sheets to do so.

It’s a simple process that only takes a few clicks.

We will also provide an example so that you can see how it works.

Let’s get started!

## How to Calculate Average in Google Sheets

Calculating the average of a dataset seems like a very straightforward task.

However, it can be pretty taxing in cases where you have to deal with multiple values simultaneously.

Manually adding and dividing numbers takes quite a long time to perform.

Thankfully, spreadsheet applications like Google Sheets and Microsoft Excel have good options for performing averaging.

## Calculating Average in Google Sheets

Suppose this is the dataset we will use for the succeeding methods.

We want to find the average of this particular studentâ€™s grades.

## Method 1. Using the â€śFunctionsâ€ť button

### Step 2. Highlight the desired cells

Left-click your mouse, hold and drag the cursor over your desired range of cells.

This should make the selected cells appear with a blue border/highlight.

### Step 3. Click on the â€śFunctionsâ€ť button

The â€śFunctionsâ€ť button is the last button in Google Sheetâ€™s toolbar.

### Step 4. Click on the â€śAverageâ€ť option

The â€śAverageâ€ť option is the second option in the drop-down menu.

The â€śAverageâ€ť option should automatically add the appropriate AVERAGE formula to the formula bar and the cell below your selected dataset.

### Step 5. Click â€śEnterâ€ť on your keyboard

Clicking the â€śEnterâ€ť button on your keyboard should automatically show the average on the cell with the added formula.

## Method 2. Using the AVERAGE formula

This method entails manually inputting the AVERAGE formula and the coordinates of the desired cells into the formula bar.

### Step 2. Locate your desired cell rangeâ€™s coordinates

The cell rangeâ€™s coordinates are at each end of the sheet.

The coordinates consist of a column letter and a row number.

From this example, we can identify that the coordinates of the desired data are from B2 to B8.

### Step 3. Click on the cell you want the calculated average to appear

A blue border should surround the selected cell.

### Step 4. Input the AVERAGE formula

Click on the formula bar and input the AVERAGE formula together with the cell range. The formula should look like this:

=AVERAGE(B2:B8)

### Â Â Â Â Â Â Â Â Step 5. Click â€śEnterâ€ť on your keyboard

Clicking the â€śEnterâ€ť button on your keyboard should automatically show the average on the cell you initially selected.

## Method 3. Using the Quick View Box

This method is more or less a bonus method as it only provides a quick view of the average of your dataset.

### Step 1. Highlight your desired cells

Left-click, hold and drag your cursor over the cells with the data you want to average.

Highlighted cells should appear light blue with a darker blue border.

### Step 2. Click on the button found at the bottom right portion of your sheet and then click on the â€śAverageâ€ť option

This button is beside the star-shaped explore one. By default, it will show the sum of your highlighted cells.

Clicking on it should show the following drop-down menu:

Click on the â€śAvgâ€ť option with the preview of the datasetâ€™s average.

Clicking on it should replace the sum button with a preview of the average.

## Summary

That’s the end of this tutorial.