Exceljet

Quick, clean, and to the point

Excel MINIFS Function

Excel MINIFS function
Summary 

The Excel MINIFS function returns the smallest numeric value that meets one or more criteria in a range of values. MINIFS can be used with criteria based on dates, numbers, text, and other conditions. MINIFS supports logical operators (>,<,<>,=) and wildcards (*,?) for partial matching.

Purpose 
Get minimum value with criteria
Return value 
Minimim value
Syntax 
=MINIFS (min_range, range1, criteria1, [range2], [criteria2], ...)
Arguments 
  • min_range - Range of values used to determine minimum.
  • range1 - The first range to evaluate.
  • criteria1 - The criteria to use on range1.
  • range2 - [optional] The second range to evaluate.
  • criteria2 - [optional] The criteria to use on range2.
Usage notes 

In the example shown, the formula in H7 is:

=MINIFS(D3:D15,C3:C15,"F")
  • Criteria range(s) must be the same size and shape as the min_range.
  • The MINIFS function was introduced in Excel 2016.
  • In earlier versions of Excel you can use an array formula based on MIN and IF to find minimum values with criteria.

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.