MINIFS Function in Excel: Smallest Value Meeting Conditions

⏱ 1 min readUpdated 28 September 2026

StatisticalLevel: IntermediateAvailable in: Excel 2019+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

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.

MAXIFS · MIN

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

Keep reading

Excel Functions A–ZSEARCH Function in Excel: Position of Text (Any Case, Wildcards)Excel Functions A–ZXMATCH Function in Excel: MATCH With Better DefaultsExcel Functions A–ZLARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong