MINIFS in Google Sheets: Find the Smallest Eligible Value and Explain Zero

• Introduced: first launch date or introduction version not established by the official history reviewed.
• Availability: documented in the rolling Google Sheets service; this guide uses ordinary cells in the web editor, without a claim about identical mobile authoring workflows.
• Checked: October 14, 2026 against the official MINIFS reference. Examples were independently calculated; no native Sheets execution was performed.

=MINIFS(range, criteria_range1, criterion1, [criteria_range2, criterion2], ...)

Supply a value range and at least one condition pair. Additional pairs narrow the selection to positions meeting every condition. Google documents equal-sized ranges and a #VALUE! error for incompatible sizes. Official MINIFS reference

Google’s page includes another section for MINIFS for BigQuery using connected data columns. The examples here use ordinary web-grid ranges. Do not substitute that data-column syntax into a cell-range example without reviewing its separate context.

Enter this data in A1:D9, including its header row:

D2:D9 must hold numbers rather than number-looking labels. The zero is intentionally part of the sample, not a blank cell.

=MINIFS(D2:D9,B2:B9,"South")
=MINIFS(D2:D9,B2:B9,"South",C2:C9,"Ready")

Expected results: 9 and 12. The first includes both South records. Adding Ready excludes K05’s held quantity of nine.

Conditions are combined as AND requirements. The same position must satisfy each pair. A pair requiring North and another requiring South on the same zone range would not select either zone as an OR rule.

=MINIFS(D2:D9,B2:B9,"North",C2:C9,"Ready")
=MINIFS(D2:D9,B2:B9,"North",C2:C9,"Ready",D2:D9,">0")

Expected results: 0 and 18. The second formula excludes K06 and selects the minimum of 18, 25 and 25.

A positive-only restriction is appropriate only when the task requires it. Zero may be a real quantity, and discarding it merely because it lowers the minimum can misrepresent the data. State the inclusion rule before creating the formula.

Put 20 in F2 and use:

=MINIFS(D2:D9,B2:B9,"North",C2:C9,"Ready",D2:D9,">="&F2)

Expected result: 25. With F2 changed to 18, the expected minimum becomes 18, because the comparison includes the threshold.

The operator must be joined to the cell value. ">=F2" is literal text, not an instruction to read F2. Keep a few below-boundary, on-boundary and above-boundary examples when reviewing adjustable criteria.

=MINIFS(D2:D9,B2:B9,"East")

Expected result: 0, although no East row is present. Google explicitly documents this no-match behavior. It is therefore different from a calculation error and will not be intercepted merely by IFERROR.

For a visible distinction:

=IF(COUNTIFS(B2:B9,"East")=0,"No matching rows",MINIFS(D2:D9,B2:B9,"East"))

Expected result: No matching rows. COUNTIFS must mirror every relevant criterion. If a minimum requires positive units, the count should require them too rather than counting unusable rows.

Enter North, South, West, East in F5:F8. In G5 use:

=MINIFS($D$2:$D$9,$B$2:$B$9,F5,$C$2:$C$9,"Ready",$D$2:$D$9,">0")

Fill down through G8. Expected results: 18, 12, 16, 0. The last zero means no eligible record; an adjacent count or the explicit label pattern can prevent it being mistaken for a positive East quantity.

The minimum value does not itself identify a unique row. If two records share a minimum, a follow-on lookup requires a deliberate tie policy. Retain the underlying records instead of assuming a summary contains all relevant context.

=MINIFS(D2:D9,B2:B8,"North")

Expected result: #VALUE!, because the eight-row value range and seven-row condition range differ in size. Google uses this error family for its documented size restriction.

Also check that ranges begin and end on the same intended record rows. Equal dimensions are necessary but cannot prove semantic alignment or correct column selection. A range that includes a header in one argument but excludes it in another deserves investigation even if its dimensions look similar.

A matching-row count does not prove every source quantity is numeric. Validate imported blanks, text and error values separately. Avoid assuming Excel’s argument-count limits or blank-criterion rules when they are not stated in the checked Google reference.

Use the ordinary MIN on a manually listed set of eligible sample quantities as an independent control. If it disagrees with the intended conditional result, inspect the conditions and record boundaries before adding another layer of error handling.

Verification: Expected results use fictional data and independent calculations rather than native Google Sheets observations. See the editorial testing standards.