MINIFS
Formulas / MINIFSFind the minimum value in a range using criteria.
MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
- min_range - the actual range of cells to determine the minimum value in
- criteria_range1 - the range of cells to evaluate with the criteria
- criteria1 - the criteria that defines which cells will be evaluated as minimum
- criteria_range2, ... [OPTIONAL] - additional ranges and their associated criteria
Examples
=MINIFS(A1:A100,B1:B100,">50")The MINIFS function can be used to select the minimum value in a range of values that meet certain criteria. For example, the formula will return the smallest value in A1:A100 where the corresponding value in B1:B100 is greater than 50.
=MINIFS(A1:A100,B1:B100,">50",C1:C100,"<100")The MINIFS function can be used to select the minimum value in a range of values that meet multiple criteria. For example, the formula will return the smallest value in A1:A100 where the corresponding value in B1:B100 is greater than 50 and the corresponding value in C1:C100 is less than 100.
=MINIFS(A1:A100,B1:B100,">50",C1:C100,"Blue")The MINIFS function can be used to select the minimum value in a range of values that meet multiple criteria specified as text. For example, the formula will return the smallest value in A1:A100 where the corresponding value in B1:B100 is greater than 50 and the corresponding value in C1:C100 is the text string "Blue".
Summary
The MINIFS function is a useful tool for finding the smallest value from a set of conditions or criteria, available on both Windows and Mac operating systems.
- The MINIFS function can handle up to 126 range/criteria pairs, with each new condition requiring a separate range and criteria set for it to be included in the final result.
- The MINIFS function supports logical operators such as ">", "<", "<>", and "=" for comparison.
- The MINIFS function also supports wildcards for partial matching, allowing users to apply criteria to dates, numbers, or text.
- For all conditions to be met, all criteria must be satisfied.
Frequently Asked Questions
What is the MINIFS function?
What Office versions support the MINIFS function?
How do I use the MINIFS function?
MINIFS(range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
What are the arguments for the MINIFS function?
- range: The range of cells to evaluate for the lowest value.
- criteria_range1, criteria1: The first range and associated criteria to evaluate.
- criteria_range2, criteria2: (Optional) The second range and associated criteria to evaluate.
- ...: (Optional) Additional range and criteria pairs to evaluate.
How many arguments can be used in the MINIFS function?
