How to Use Excel AVERAGE Function in Office 365? – [with Examples]
Tags: excelaveragefunction, excelfunctions
Published: 2020-09-21 12:20:33

---
title: How to Use Excel AVERAGE Function in Office 365? – [with Examples]
published: true
date: 2020-09-21 09:06:50 UTC
tags: ExcelAVERAGEFunction,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-average-function-in-office-365-with-examples/
---

## Excel AVERAGE Function:

![AVERAGE Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/AVERAGE-Function.png)<figcaption id="caption-attachment-14365">AVERAGE Function</figcaption>

In this tutorial, we will guide you to learn the usage of **Excel AVERAGE Function in Office 365** with its syntax, description, and examples. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **AVERAGE Function – Description:**

- This function **returns the arithmetic mean of given input numbers**.
- **AVERAGE** will **accept up to 255 arguments** that can be numbers, array, cell references, ranges, and constants.

## **Syntax:**

**=AVERAGE(number1, [number2],..)**

### Arguments Explanation:

**Number1 – ** It is the first input number, cell reference, or range.

**Number2 – ** It is an optional one. This is the second input number, cell reference, or range.

### Note:

- If the arguments contain **Text** , **Logical**  **values** , or **Empty**  **cells** , it will be ignored.
- This function includes **zero** values.

## **Examples:**

Let’s see some examples to understand this concept quickly.

### Example 1:

- In the below example image, you can see the input numbers in **Column B** , **C** , and **D**. The output values are displayed in **Column F**.

![Example 1](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-81.png)<figcaption id="caption-attachment-14347">Example 1</figcaption>

### Example 2 – Ignores Blank Cell:

- If the arguments contain **Text** , **Logical**  **values** , or **Empty**  **cells** , it will be ignored.
- This function includes **zero** as values.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-76.png)<figcaption id="caption-attachment-14348">Example 2</figcaption>

## **Mixed Arguments:**

- You can also use **mixed arguments** ( **mix of references and constants** ) in this function.
- The below screenshot has shown mixed arguments in the formula bar as ( **B3** , **B4** , **B5** , **22** , **18** ) and its output is printed in **Cell D3**.

![Mixed References](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-37.png)<figcaption id="caption-attachment-14352">Mixed References</figcaption>

## **AVERAGE with Criteria:**

- If you need to **find an average** for the range of input cells with any **criteria** or **condition** , then you can use [**AVERAGEIF**](https://geekexcel.com/how-to-use-excel-averageif-function-in-office-365-with-examples/)or [**AVERAGEIFS**](https://geekexcel.com/how-to-use-excel-averageifs-function-in-office-365-with-examples/)functions in Excel.
- Refer to the below example where you can see the input ranges in **Column C** & **D**. The output is printed in the cells **G3** ( **average marks of female** ) & **G4** ( **average marks of male** ).

![Example for Average with Criteria](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/4-15.png)<figcaption id="caption-attachment-14354">Example for Average with Criteria</figcaption>

## **AVERAGE top n Values:**

- You can also calculate an **average of top n values by combining AVERAGE and [LARGE Function](https://geekexcel.com/how-to-use-excel-large-function-in-office-365-with-examples/). **
- This screenshot has shown the formula in the formula bar. It represents the top 3 values from each row.

![Average of top n values](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/5-7.png)<figcaption id="caption-attachment-14355">Average of top n values</figcaption>

## **Weighted Average:**

- If you want to calculate the weighted average, you need to use [**SUMPRODUCT**  **Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- In this image, you can see the **input ranges in Column B, C, and D**. The weights are given in the range **G4:I4. **
- The **weighted**  **average**  **values** are listed in **Column E**.

![Weighted Average](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/6-5.png)<figcaption id="caption-attachment-14362">Weighted Average</figcaption>

From the above examples, you can clearly understand how to use the AVERAGE Function in various ways.

## **Conclusion:**

In this tutorial, we guided you to learn the usage of **Excel AVERAGE Function in Office 365** with its syntax, description, and examples. Kindly, leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel T Function in Office 365? [With Examples]](https://geekexcel.com/how-to-use-t-function-in-microsoft-excel-365-with-examples/)

- [How to Use Excel SHEETS Function in Office 365? – [With Examples]](https://geekexcel.com/how-to-use-excel-sheets-function-in-office-365-with-examples/)