# How To Use AVERAGE Function In Google Sheets

Google Sheets is a powerful tool for data analysis and organization.

One of the most useful functions in Google Sheets is the AVERAGE function, which can quickly calculate the average of a range of cells.

In this article, we will show you how to use the AVERAGE function in Google Sheets and provide some examples of its various applications.

## Examples Of Using AVERAGE Function

### Example 1: Calculating The Average Of A Column Of Numbers

Let’s say you have a column of numbers in cells A1 to A10, and you want to calculate the average of those numbers.

Here’s how you would use the AVERAGE function to do that:

1. Select the cell where you want the average to appear (e.g. B1)
2. Type the formula `=AVERAGE(A1:A10)` in the formula bar, then press Enter

This will calculate the average of the numbers in cells A1 to A10 and display the result in cell B1.

### Example 2: Calculating The Average Of A Range Of Cells With Decimal Places

In this example, let’s say you have a range of cells with decimal places, and you want to calculate the average of those cells.

Here’s how you would do that:

1. Select the cell where you want the average to appear (e.g. B1)
2. Type the formula `=AVERAGE(A1:A10)` in the formula bar, then press Enter

This will calculate the average of the decimal numbers in the range of cells A1 to A10 and display the result in cell B1.

### Example 3: Calculating The Average Of A Range Of Cells With Multiple Criteria

In this example, let’s say you have a range of cells with multiple criteria, and you want to calculate the average of those cells based on certain criteria.

Here’s how you would do that:

1. Select the cell where you want the average to appear (e.g. B1)
2. Type the formula `=AVERAGEIF(A1:A10,"criteria",B1:B10)` in the formula bar, then press Enter

This will calculate the average of the cells in the range A1:A10 based on the criteria specified in the formula, and display the result in cell B1.

## Conclusion

The AVERAGE function in Google Sheets is a powerful tool for data analysis and organization.

It allows you to quickly calculate the average of a range of cells, making it an essential function for any data analyst or spreadsheet user.

With the examples provided in this article, you should now have a good understanding of how to use the AVERAGE function in Google Sheets and be able to apply it to your own data.