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

---
title: How to Use Excel AVERAGEIF Function in Office 365? – [with Examples]
published: true
date: 2020-09-16 09:15:35 UTC
tags: ExcelAVERAGEIFFuncti,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-averageif-function-in-office-365-with-examples/
---

## AVERAGEIF Function:

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

In this post, you will learn the usage of **Excel AVERAGEIF Function in Office 365** with its syntax, explanation, and examples. Let’s get 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)

## **AVERAGEIF Function – Description:**

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

## Syntax:

**=AVERAGEIF(range, criteria, [average\_range])**

### Arguments Explanation:

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

**Criteria – ** You can give criteria in the form of a number, expression, cell reference, or text.

**Average\_range – ** It is an optional one. This is the set of cells to find the average. If it is omitted, range is used.

### Note:

- This function ignores the  **Logical**  **values** , **Empty**  **cells**.
- The arguments can be **Numbers** , **Array** , or **References** that contain numbers.
- 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 know-how the AVERAGEIF function will work.

### Example 1:

- In the below screenshot, you can be able to see the input range in **Column C** , and the output average value is printed in the **Cell E3**.

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

### Example 2:

- This function ignores the  **Logical**  **values** , **Empty**  **cells,** and **Text**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-51.png)<figcaption id="caption-attachment-14018">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/3-17.png)<figcaption id="caption-attachment-14019">Example 3</figcaption>

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

## Wrap-Up:

In this article, you can understand the usage of **Excel AVERAGEIF Function in Office 365** with its syntax, explanation, and examples. Drop your **feedback** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [How to Use Excel STDEV.P Function in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-stdev-p-function-in-office-365-with-examples/)
- [How to Use Excel COMBIN Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-combin-function-in-office-365-with-examples/)