How to Use Excel AVERAGEIFS Function in Office 365? – [with Examples]
Tags: excelaverageifsfunct, excelfunctions
Published: 2020-09-17 04:17:57

---
title: How to Use Excel AVERAGEIFS Function in Office 365? – [with Examples]
published: true
date: 2020-09-16 09:25:11 UTC
tags: ExcelAVERAGEIFSFunct,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-averageifs-function-in-office-365-with-examples/
---

## AVERAGEIFS Function:

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

In this tutorial, we will guide you to learn the usage of **Excel AVERAGEIFS Function in Office 365** with its syntax, explanation, and examples. Let jump 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)

## **AVERAGEIFS Function – Explanation:**

- This function **returns the average of a set of input values that meet the multiple criteria**.
- AVERAGEIFS function is similar to the **AVERAGEIF**  **function**.
- The criteria can be defined using logical operators such as ( **<, >, =, <>, \*, ?** ).

## Syntax:

**=AVERAGEIF(average\_range, range1, criteria1, [range2], [criteria2],…)**

### Arguments Explanation:

**Average\_range – ** It is the range to find average.

**Range1 – ** It is the range of input values that contain numbers.

**Criteria1 – ** It is the criteria to use in range 1.

**Range2 – ** It is an optional one. It is the second range to find the average.

**Criteria2 –** It is an optional one. The second criteria to use in range 2.

### Note:

- This function ignores the **text** , **Empty**  **cells** , **special characters**.
- The arguments can be **Numbers** , **Array** , or **References** that contain numbers.
- This function evaluates logical values **TRUE & FALSE** as **1** and **0**.
- If the range is **blank** or **text**  **value** and then this function returns [**#DIV/0! Error**](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/).
- If any cell in the range doesn’t meet the given condition or criteria, then this function returns [**#DIV/0! Error**](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/).

## Examples:

Let’s see some examples to understand this function easily.

### Example 1:

- In the below screenshot, you can be able to see the input **range 1** in **Column C** , **range 2** in **Column D** and their criteria are “ **>80** ” and “ **B** ” which means student score should be **greater than 80** and the **rank should be B**.
- The output average value is displayed in the **Cell F3**.

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

- If you want to round the output average value to the desired digits, you need to use the [**Excel ROUND Function**](https://geekexcel.com/how-to-use-excel-round-function-in-office-365-with-examples/).

### Example 2:

- This function ignores the **text** , **Empty**  **cells** , **special characters**.

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

### Example 3:

- If the range is **blank** or **text**  **value** and then this function returns [**#DIV/0! Error**](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/).
- If any cell in the range doesn’t meet the given condition or criteria, then this function returns [**#DIV/0! Error**](https://geekexcel.com/how-to-fix-div-0-error-in-excel-office-365-with-example/).

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

From the above examples, you can learn how to use the **AVERAGEIFS**  **function**.

## Closure:

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

### Keep Reading:

- [How to Use Excel MODE.SNGL Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-mode-sngl-function-in-office-365-with-examples/)
- [How to Use Excel SMALL Function in Office 365? – (with Examples](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)[)](https://geekexcel.com/how-to-use-excel-small-function-in-office-365-with-examples/)