fx
FunctionPedia
Quick Answer

MINIFS Function

Finds the smallest value where multiple conditions are all true.

✓ Excel✓ Google SheetsExcel Excel 2019+

Syntax

MINIFS
(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

Parameters

ParameterDescriptionRequired
min_rangeThe range of cells from which the minimum is returned.Required
criteria_range1The first range tested against criteria1; must be the same size as min_range.Required
criteria1The condition for criteria_range1 (e.g. "Apple", ">100", "West").Required
criteria_range2, criteria2, ...Optional additional range/criteria pairs; all must be met (AND logic).Optional

Basic Example

Smallest sale for a specific product

=MINIFS(C2:C10, A2:A10, "Apple")
Result500

Among rows where column A is Apple, the smallest value in column C (e.g. 500) is returned.

Advanced Examples

Example 1: Minimum with two criteria

Lowest sale in a region meeting a threshold

Both conditions must be satisfied (AND logic).

=MINIFS(C2:C100, A2:A100, "West", B2:B100, ">=100")
Result: 120
Only rows where region is West AND column B is at least 100 are considered; the smallest such column C value is 120.

Example 2: Criterion with a cell reference

Reusable threshold in a cell

Concatenate a comparison operator with a cell value.

=MINIFS(C2:C50, A2:A50, "Banana", B2:B50, ">"&E1)
Result: 80
If E1 holds 50, this finds the smallest column C for Banana where column B exceeds 50, here 80.

How MINIFS Works

MINIFS evaluates each criteria_range against its criteria, keeping only the rows where all conditions are true. It then returns the minimum value from min_range at those rows. All ranges must have the same dimensions. If no row satisfies every criterion, MINIFS returns 0. Criteria support operators (>, <, >=, <=, <>) and wildcards (*, ?) for text. It is the conditional counterpart of MIN, analogous to SUMIFS for SUM.

1
Select the result cell
Click where you want the minimum.
2
Enter the formula
Type =MINIFS(min_range, criteria_range1, criteria1, ...).
3
Press Enter
The conditional minimum appears.

Important Notes & Limitations

  • All ranges must be the same size; mismatched sizes cause #VALUE!.

  • Applies AND logic only; OR logic requires separate formulas combined with MIN.

  • Returns 0 when no row meets all criteria, which can be confused with a real zero.

Common Errors & Fixes

#VALUE! errorThe criteria ranges and min_range have different sizes or shapes.

Fix: Ensure every range covers the same rows and columns.

Wrong minimum returnedCriteria text does not exactly match, including case differences or stray spaces.

Fix: Use exact text, trim spaces, or use wildcards for partial matches.

Download Practice File

Practice MINIFS with Real Data

Download a sample CSV file with pre-populated data and practice exercises for the MINIFS function. Works in both Excel and Google Sheets.

Works in Google SheetsCompatible with ExcelIncludes exercises

File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps

Frequently Asked Questions

Can MINIFS use OR logic?
No, it only applies AND across criteria pairs. For OR, compute separate MINIFS and wrap them in MIN, or use MIN with FILTER.
Why do I get 0?
No row satisfied all criteria, and MINIFS returns 0 in that case. Check your criteria and ranges.
Which Excel versions have MINIFS?
MINIFS was introduced in Excel 2019 and is also in Microsoft 365; it is not available in Excel 2016 and earlier.