Apple Numbers MINIFS: Lowest Qualifying Value and Missing-Match Checks

• Introduced: The original release and introduction date are not established by the checked references.
• Availability: Currently documented in Apple’s Functions Help 15.4 documentation edition. No final supported-version endpoint is established.
• Scope: Shared iWork reference; exact historical availability in individual Mac, iPad, iPhone and iCloud builds remains unverified.
• Checked: October 14, 2026, against the official MINIFS reference. Examples checked by independent typed-value and selection models; no native Numbers test.

=MINIFS(range, criteria-range, criteria, criteria-range…, criteria…)

The result range and first criteria-range/condition pair are required; more pairs are optional. Apple’s entry requires the result range and each criteria range to have equal size. A size mismatch returns an error, and no matching criteria returns 0.

The result values cannot mix date/time or duration types with other types. Text and booleans may occur in referenced result cells, but direct text/boolean result arguments are outside the documented rule. Ordinary text criteria remain allowed.

The complete numeric datasets here avoid relying on unspecified blank, error or coercion behavior. Every condition selects the corresponding record; it is not a separate minimum computed from another column.

Create a Numbers table named Quotes, with ten columns A:J and ten rows including one header row. Put Quote ID, Source, Status, Price and Quantity in A1:E1. Enter:

The numeric zero in Q106 is deliberately entered data, not a blank. Use G for result labels, H for formulas and J for changing criteria.

The two price-48 Local records meet the ten-unit requirement. Requiring more than 12 units leaves only Q104 at 55. Requiring at least 16 leaves no qualifying Local record, producing the documented zero fallback.

These rules are illustrative eligibility conditions, not a procurement recommendation. If a zero price is itself invalid under your policy, express that as another condition rather than expecting MINIFS to infer it.

Put Local in J2 and 10 in J3. Enter this in H10:

=MINIFS(D2:D9,B2:B9,J2,C2:C9,"Approved",E2:E9,">="&J3)

Expect 48. Change only J3 to 13; H10 becomes 55. Change it to 16; H10 becomes 0. Restore J3 to 10 afterward. H2:H9 do not depend on J3 and retain their original results.

The operator and criterion value are joined with &, following the condition-based function rules. This is a minimum over the selected prices, not a multiplication of price by quantity.

Create a separate QuoteSummary table with five columns and five rows. Use Source, Qualifying quotes, Minimum, Display and Tied winners as A1:E1. Enter Local, Import, Remote, Missing in A2:A5.

Enter the following formulas in row 2, then fill B2:E2 to row 5:

B2: =COUNTIFS(Quotes::B$2:B$9,A2,Quotes::C$2:C$9,"Approved",Quotes::E$2:E$9,">=10")
C2: =MINIFS(Quotes::D$2:D$9,Quotes::B$2:B$9,A2,Quotes::C$2:C$9,"Approved",Quotes::E$2:E$9,">=10")
D2: =IF(B2=0,"No matches",C2)
E2: =COUNTIFS(Quotes::B$2:B$9,A2,Quotes::C$2:C$9,"Approved",Quotes::E$2:E$9,">=10",Quotes::D$2:D$9,C2)

The leading B2:/C2: labels specify destinations; enter only the formulas after those labels.

COUNTIFS exposes how many records are eligible. IF gives the missing group an explicit text label. Keep the underlying numeric minimum in C rather than mixing that text into the price column.

The tied-winner count prevents assuming that one minimum identifies a unique supplier or quote. Any rule for choosing among tied records is an additional policy, not part of MINIFS.

Make a separate two-column QuoteZeroCheck table with five rows:

The first zero comes from absence; the second minimum comes from the explicitly entered zero-price record. A missing group must not look like a free qualifying quote.

Keep ranges aligned by record and equal in size. A shifted range can select the wrong price even when its length is valid. Apple’s generic size-error rule does not specify every exact native error token, and the short entry leaves other mixed-type boundaries unstated.

Use Numbers’ table-qualified references when moving summaries between tables. MAXIFS selects the largest eligible value; MIN ignores criteria, and SUMIFS answers an aggregate-total question.