MINIFS

Formulas / MINIFS
Find 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?
The MINIFS function is a built-in function in Microsoft Office and Microsoft 365 that returns the lowest value in a set of cells specified by a given set of conditions or criteria.
What Office versions support the MINIFS function?
The MINIFS function is available on Windows or Mac with Office 2019 or Microsoft 365.
How do I use the MINIFS function?
The MINIFS function has the following syntax:
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?
The MINIFS function can have up to 126 arguments, including the range and associated criteria pairs.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV