Please note javascript is required for full website functionality.

# A to Z of Excel Functions: The MINIFS Function

23 May 2022

Welcome back to our regular A to Z of Excel Functions blog. Today we look at the MINIFS function.

The MINIFS function

The MINIFS function returns the minimum value among cells specified by a given set of conditions or criteria.  It has the following syntax:

MINIFS(min_range, criterion_range1, criterion1, [criterion_range2, criterion2], ...)

where:

• min_range is the actual range of cells in which the minimum is to be determined
• criterion_range1 is the set of cells to evaluate with the criterion specified
• criterion1 is the criterion in the form of a number, expression or text that defines which cells will be evaluated as a minimum
• criterion_range2 (onwards) and criterion2 (onwards) are the additional ranges and their associated criteria.  126 range / criterion pairs may be specified.  All ranges must have the same dimensions otherwise the function returns an #VALUE! error.

It should be noted that:

• the size and shape of the min_range and criteria_rangeN arguments must be the same, otherwise these functions return the #VALUE! error.

As an example:

This example is preferable to its standard Excel counterpart:

{=MIN(IF(G13:G31=H34,IF(H13:H31=H35,IF(I13:I31=H36,J13:J31))))}

Array formulae (see Array of Lightfor more information) are cumbersome and not readily understood, which is why MINIFS may be a highly viable alternative.

We’ll continue our A to Z of Excel Functions soon. Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here.