MINIFS Function in Excel: Smallest Value Meeting Conditions

📎 This article includes 1 downloadable practice file ↓

StatisticalLevel: IntermediateAvailable in: Excel 2019+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. MINIFS in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

MINIFS returns the minimum of values where all conditions are true.

Syntax

=MINIFS(min_range, criteria_range1, criteria1, ...)

Argument	What it means
min_range	Values to check.

Examples

Example 1

=MINIFS(A:A, C:C, F2)

First order date for a customer.

Example 2

=MINIFS(E:E, E:E, ">0")

Smallest non-zero value.

MINIFS in practice

Where you will use it

• Lowest price quoted per supplier
• Earliest date per customer
• Minimum stock in a category

Worked example

Supplier	Price	Formula	Result
Alpha	120	=MINIFS($B$2:$B$4,$A$2:$A$4,A2)	105
Beta	110	=MINIFS($B$2:$B$4,$A$2:$A$4,A3)	110
Alpha	105	=MINIFS($B$2:$B$4,$A$2:$A$4,A4)	105

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Blanks treated as 0?	Blanks are ignored, but typed zeros count
Older Excel	Needs 2019 or 365

Related functions

MAXIFS · MIN

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Statistical guides →

GAMMAINV Function in Excel: Inverse Gamma (Older Name)GAMMAINV returns the value at a gamma probability. It is a compatibility function: Excel…GAMMADIST Function in Excel: Gamma Distribution (Older Name)GAMMADIST returns the gamma probability. It is a compatibility function: Excel keeps it so…TTEST Function in Excel: t-Test (Older Name)TTEST returns the p-value of a t-test between two samples. It is a compatibility…GAMMA.INV Function in Excel: Value for a Gamma ProbabilityStatisticsLevel: ExpertAvailable in: Excel 2010+GAMMA.INV returns the value at a given gamma probability.Syntax=GAMMA.INV(probability, alpha.

📎 Practice files for this article

• 📗
  Practice workbook: Statistics basics22 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 34 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.