How to Use Excel MAXIFS Function in Office 365? – [with Examples]
Tags: excelfunctions, excelmaxifsfunctioni
Published: 2020-09-19 10:39:11

---
title: How to Use Excel MAXIFS Function in Office 365? – [with Examples]
published: true
date: 2020-09-19 08:10:56 UTC
tags: ExcelFunctions,ExcelMAXIFSFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-maxifs-function-in-office-365-with-examples/
---

## Excel MAXIFS Function:

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

In this article, we are going to see the usage of **Excel MAXIFS Function in Office 365** with its syntax, explanation, 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)
## **MAXIFS Function – Description:**

- **MAXIFS** Function **returns the largest numeric value from the range of input values based on the given condition or criteria.**
- This function supports logical operators such as ( **<** , **>** , **=** , **<>** , **?** , **\*** ).

## **Syntax:**

**=MAXIFS(max\_range, range1, criteria1, [range2], [criteria2],.. )**

### Arguments Explanation:

**max\_range –** The input range or array from which the maximum value will be found.

**range1 – ** It is the first input range to evaluate.

**criteria1 – ** This is the criteria or condition to use on the range 1.

**range2 – ** It is an optional one. It is the second input range to evaluate.

**criteria2 – ** It is an optional one. The criteria or condition to use on the range 2.

### Note:

- The max\_range & criteria\_range are should be same otherwise it returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).
- This function ignores the **Text** , **Logical**  **values** , **Blank**  **cells** , and **Special**  **symbols**.

## **Examples:**

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

### Example 1:

- In the below screenshot, you can be able to see the **max\_range** in **Column**  **D** , the **criteria\_range** in **Column**  **C**.
- The output value is displayed in **Cell G3** ( **for Female** ) and **G4** ( **for Male** ).

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

### Example 2:

- The **max\_range** & **criteria\_range** are should be the same otherwise it returns [**#VALUE! Error**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/).

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

From the above examples, you can learn how to use **MAXIFS** Function.

### Video Tutorial:

<!--[if lt IE 9]><script>document.createElement('video');</script><![endif]--><video id="video-14269-1" width="770" height="433" preload="metadata" controls="controls"><source type="video/mp4" src="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/My-Movie_1-1.mp4?_=1"></source><a href="https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/My-Movie_1-1.mp4">https://geekexcel.com/wp-content/uploads/2020/09/My-Movie_1-1.mp4</a></video>

## **End of the Article:**

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

### Read Ahead:

- [How to Use “Excel SIGN Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-sign-function-in-office-365-with-examples/)
- [How to Fix #SPILL! Error in Excel Office 365? – [with Example]](https://geekexcel.com/how-to-fix-spill-error-in-excel-office-365-with-example/)