MINIFS Function Formula
The below formula will return the smallest value from a range based on the criteria you set.
=MINIFS (min_range, criteria_range1, criteria1, [criteria_range2], [criteria2], …)
Here’s what each argument represents:
- min_range: This is the range of values you want to find the minimum from.
- criteria_range1: The first range where you want to apply a condition.
- criteria1: The condition to apply to criteria_range1.
- [criteria_range2, criteria2, …]: Optional additional ranges and criteria. You can have multiple pairs of criteria ranges and criteria.
How to use MINIFS function in Microsoft Excel
The MINIFS function in Excel is a powerful tool for filtering and analyzing data. It allows you to find the smallest numeric value in a range of cells that meet one or more specified requirements. This can be useful for a variety of tasks, such as finding the lowest price for a product in a specific category, finding the shortest delivery time for a product, finding the highest test score for a student in a particular class, or finding the lowest employee salary in a department.
Contact Us