How to Use Excel MINIFS Function in Office 365? – [with Examples]
Tags: excelfunctions, excelminifsfunctioni
Published: 2020-09-15 06:35:12

---
title: How to Use Excel MINIFS Function in Office 365? – [with Examples]
published: true
date: 2020-09-14 12:14:46 UTC
tags: ExcelFunctions,ExcelMINIFSFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-minifs-function-in-office-365-with-examples/
---

## MINIFS Function:

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

In this article, you will understand the usage of **Excel MINIFS 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)

## **MINIFS Function – Explanation:**

- This function returns the minimum value from the given input values specified by one or two conditions.
- The criteria are based on dates, numbers, text, or other conditions.
- This function also supports logical operators such as **<** , **>** , **=** , **<>** ( **not equal to** ).

## **Syntax:**

**=MINIFS(min\_range, range1, criteria1, [range 2], [criteria2]…)**

### Arguments Explanation:

**min\_range – ** The range of values from which you want to find the minimum value.

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

**criteria1 – ** The criteria to use range 1.

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

**criteria2 –** It is an optional one. The criteria to use range 2.

### **Note:**

- If no cells match the criteria, this function returns 0.
- The criteria range must be the same size as the minimum range otherwise it returns [**#VALUE!**](https://geekexcel.com/how-to-fix-value-error-in-excel-office-365-with-example/) Error.

## **Examples:**

Here are examples to understand how to use **MINIFS Function**.

### Example 1:

- In the below screenshot, you can see the input **Columns B and C** , and the output is printed in the **cells F3** and **F4**.

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

### Example 2:

- The criteria range must be the same size as the minimum range 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-41.png)<figcaption id="caption-attachment-13862">Example 2</figcaption>

## **Conclusion:**

In the above article, you can clearly understand the usage of **Excel MINIFS 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!!

### See Also:

- [How To Use Excel NOT Function in Office 365?](https://geekexcel.com/how-to-use-not-function-in-microsoft-excel-365/)
- [How to Use Excel QUOTIENT Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-quotient-function-in-office-365-with-examples/)