Home>Blogs>Excel Tips and Tricks>MINIFS formula in Excel with Examples
Excel Tips and Tricks

MINIFS formula in Excel with Examples

If you’re looking to simplify your data analysis in Excel, you’ve come to the right place! In this article, we’ll dive into the powerful MINIFS formula in Excel . This function is incredibly useful when you need to find the minimum value in a range that meets one or more conditions. Whether you’re working with large datasets or just need quick insights, the MINIFS function can save you time and effort. Let’s explore it step by step, along with some practical examples.

What is the MINIFS Function?

MINIFS formula in Excel
MINIFS formula in Excel

The MINIFS formula in Excel allows you to return the smallest numeric value from a range, based on one or more criteria. It’s a conditional version of the MIN function, enabling you to apply specific conditions before calculating the minimum.

Syntax:

=MINIFS (Min_ range, criteria_range1, criteria1, [criteria_range2, criteria2], …)

  • min_ range: The range where you want to find the minimum value.
  • criteria_range1: The range that is evaluated with the condition.
  • criteria1: The condition that must be met.
  • You can add more criteria ranges and conditions as needed.

Now, let’s jump into a real-life example to help you understand how the MINIFS formula works.

How to Use the MINIFS Function in This Example

MINIFS Function
MINIFS Function

Let’s say you want to find the minimum sales value in Mumbai. To achieve this, we will use the MINIFS formula in Excel .

Here’s how you can apply the MINIFS formula:

=MINIFS (D3:D22, B3:B22, “Mumbai”)

  • D3: This is the range where the sales values are stored.
  • B3: This is the range where the city names are stored.
  • “Mumbai”: This is the criteria we are applying, meaning we want to find the minimum sales for employees based in Mumbai.

Output of the Formula:

By applying this formula, you’ll get the smallest sales figure for Mumbai, which is 2,200.

Exploring Other Use Cases

  • Minimum Sales in the SEO Department

Let’s say you want to find the minimum sales made by employees in the SEO department, regardless of their location. Here’s how you can modify the formula:

=MINIFS (D3:D22, C3:C22, “SEO”)

: The range where the department names are stored.

  • “SEO”: The criteria, targeting only the SEO department.

The result will give you the minimum sales made by employees in the SEO department.

  • Combining Multiple Conditions

If you want to find the minimum sales in Mumbai for the SEO department, you can combine both conditions:

=MINIFS(D3:D22, B3:B22, “Mumbai”, C3:C22, “SEO”)

This formula searches for employees who are both based in Mumbai and work in the SEO department. It then returns the lowest sales figure from that filtered group.

Why Should You Use MINIFS?

The MINIFS function is an invaluable tool in Excel, especially when you’re dealing with complex data analysis. Here are some key advantages:

  • Timesaving: Instantly retrieves the minimum value based on multiple conditions, without needing to filter or sort data manually.
  •  Accurate results: Ensures you only calculate values that meet your specific criteria, minimizing errors in large datasets.
  •  Easy to use: Once you understand the syntax, applying this function is straightforward and flexible for a variety of data types.

Wrapping Up

The MINIFS formula in Excel is a powerful tool to add to your Excel skills toolbox. Whether you’re working with sales data, employee performance, or any other dataset, MINIFS simplifies the process of finding the smallest value under multiple conditions.

With its ease of use and flexibility, you’ll wonder how you ever analyzed data without it! Give it a try with your datasets and see how much time you save.

Visit our YouTube channel to learn step-by-step video tutorials

Youtube.com/@PKAnExcelExpert

 

 

 

View this post on Instagram

 

A post shared by Priyendra Kumar (@pkanexcelexpert)

 

Click hare to download the practice file

 

PK
Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!
https://www.pk-anexcelexpert.com