Menu
EXCEL MINIFS FUNCTION
Excel MINIFS Function Introduction
The Excel Minifs function returns the smallest value from a collection of values defined by one or more criteria.
Description of Excel MINIFS Function
Syntax :
=MINIFS( min_range, criteria_range1, criteria1, [criteria_range2, criteria2], … )
Parameters :
- Min range – An array of numeric values (or a range of cells containing numeric values) from which the minimum value should be returned if the requirements are met.
- Criteria range1 – An array of values to be evaluated against criteria1 (or a range of cells holding values).
(Everything in this array must be the same length as the min range.) - Criteria1 – The condition to be evaluated against the criteria range1 values.
- [Criteria range2, criteria2], [criteria range3, criteria3],… – Optional additional arrays of values to be checked and the conditions to test.
Step By Step Guide of MINIFS Function
Example :
The spreadsheet below displays the quarterly sales numbers for three different sales reps. The Minifs function may be used to determine the bare minimum of sales for any quarter, territory, or sales rep.
Key Points
- #VALUE! – This error occurs if the given min range and criteria range arrays are not all of the same length.
- #NAME? – This error occurs if you are using an earlier version of Excel (before to 2019) that does not support the Minifs function.
Related Functions
HLOOKUP Function
HLOOKUP Function
Explore NowVLOOKUP Function
VLOOKUP Function
Explore NowINDEX Function
INDEX Function
Explore NowMATCH Function
MATCH Function
Explore NowDATE Function
DATE Function
Explore NowIF Function
IF Function
Explore NowOR Function
OR Function
Explore NowAND Function
AND Function
Explore NowRANK Function
RANK Function
Explore NowSUMIF Function
SUMIF Function
Explore NowXIRR Function
XIRR Function
Explore NowWORKDAYS Function
WORKDAYS Function
Explore Now
