Returns the smallest numeric value that meets one or more criteria in a given range of values
The MINIFS Function is categorized under Excel Statistical functions. It will return the smallest numeric value that meets one or more criteria in a given range of values.
In financial analysis, the MINIFS function can be used to extract a minimum numeric value. For example, we can get the minimum value of test scores by a male and a female.
=MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], …)
The MINIFS function uses the following arguments:
MINIFS supports logical operators (>, <, <>, =) and wildcards (*, ?) for partial matching. It can be used with criteria based on dates, numbers, text, and other conditions.
To understand the uses of the MINIFS function, let’s look at an example:
Suppose we are given the sales figure for 3 products from 3 regions, as shown below:
The formula to be used to find the sales figures for product A in Q2 would be:
We get the result below:
Click here to download the sample Excel file!
Thanks for reading CFI’s guide to the Excel MINIFS function. By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional CFI resources: