From data to report in one minute or less. Ajelix BI is launched! đźš€ Get started for free.

# How To Use AVERAGE function in Excel with Examples

### What is AVERAGE function in Excel?

The AVERAGE function in Excel calculates the average of a set of values. It takes the sum of the values and divides it by the number of values in the list. The result of the function is the average of the values.

### Description

The AVERAGE function in Excel calculates the average of a set of numbers. It is a simple and useful tool for totaling up values quickly and easily. The function can be used to quickly find the mean of a set of numbers. Calculate the average of a range of values or a specific set of numbers, such as a subset of a larger dataset.

The function is beneficial because it allows users to quickly calculate an average without having to manually add up each value. Additionally, it can be used to quickly compare different subsets of data and identify differences or correlations between them.

Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

### AVERAGE Function Syntax

=AVERAGE(number1, number2, …)

### How to use AVERAGE function MS Excel in your workbook:

1. Open the Excel file containing the data you want to calculate.
2. Select the cells.
3. Click the â€śHomeâ€ť tab in the ribbon at the top of the window.
4. Select the â€śAverageâ€ť icon in the â€śEditingâ€ť section of the ribbon.
5. The â€śAverageâ€ť dialog box appears on the screen.
6. Verify that the correct cells are selected.
7. Select the â€śOKâ€ť button to apply the formula.
8. The average of the selected cells will be displayed in the cell where the formula was applied.

How to calculate AVERAGE function on Excel?
1. Enter your data into a column in Excel.
2. Select the data you want to find the average of.
3. Click the â€śInsertâ€ť tab, then click â€śFunctionâ€ť in the â€śFormulasâ€ť group.
4. Select â€śAverageâ€ť from the drop-down list.
5. Click â€śOKâ€ť to insert the AVERAGE function.
6. The average of the selected data will be displayed in the cell.
Where is AVERAGE used for?

Average is used to measure the central tendency of a set of data. It is used in statistics, mathematics, and finance to quantify the average or central value of a set of data points, such as the mean, median, and mode. It is also used to calculate the average of two or more numbers, or to compare different sets of data.

### Similar Formulas

WEEKLY BLOG ARTICLES WITH INDUSTRY NEWS AND HELPFUL GUIDES

### Our Brands

#### Business Intelligence platform meets AI

Trusted by 150'000 customers around the globe since 2018.

Â© 2018 - 2024 AJELIX, SIA