What is the MINIFS Function in Excel
The MINIFS formula in Excel is a combination of the MIN and IF functions. To use it, we provide a range of values to evaluate for the minimum, along with one or more sets of criteria. Each set of criteria consists of a range and a condition, then the MINIFS would return the minimum value that meets all the specified criteria.
To define the criteria, MINIFS supports logical operators like (>,<,<>,=) and wildcards like asterisks(*) and question marks (?) to match the partial text or patterns.
Note: Note: This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription.
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