Zoho Sheet MINIFS: Eligible Quotes, Lead-Time Limits and Ties

• Introduced: Added in June 2019, according to Zoho’s release history, and announced in its June 10, 2019 post. No numbered cloud release is given.
• Availability: Currently documented in Zoho Sheet’s rolling web-service help; no retirement endpoint is established.
• Scope: English-language web-service documentation. Exact mobile and offline-client parity is not established here.
• Checked: October 14, 2026, against the official MINIFS reference. Documentation and independent typed-value/selection calculations; no native Zoho Sheet test.

=MINIFS(min_range; condition_range; condition; [condition_range1]; [condition1]; ...)

The first range supplies candidate values. It is followed by a required criteria range and condition, with additional pairs optional. Multiple criteria restrict the same candidate records; they are not instructions to take a separate minimum from each condition range.

Keep every range aligned to the same rows. The official launch explanation describes selection based on corresponding ranges. These complete numeric fixtures avoid assuming undocumented mismatch or text-candidate handling.

Create Quotes. Put ID, Material, Status, Price and Lead days in A1:E1 and enter:

Use F2:F6 for results:

The four approved steel prices are 120,120,150,140. A lead-time limit of two days leaves only the 150 quote. A higher selected minimum after tightening conditions can be correct; the eligible set changed.

In H2 enter =COUNTIFS(B2:B8;"Steel";C2:C8;"Approved"); expect 4. In H3 enter =COUNTIFS(B2:B8;"Steel";C2:C8;"Approved";D2:D8;F2); expect 2 records at the minimum price.

Put Minimum-price match in L1. In L2 enter =AND(B2="Steel";C2="Approved";D2=$F$2) and fill through L8. The expected flags are TRUE,FALSE,TRUE,FALSE,FALSE,FALSE,FALSE. Q01 and Q03 tie on price; their lead times differ. A single minimum value does not choose between them or capture every purchasing consideration.

Put 3 in J2. In J3 enter:

=MINIFS(D2:D8;B2:B8;"Steel";C2:C8;"Approved";E2:E8;"<="&J2)

Expect 120, from the eligible prices 120 and 150. In J4 enter =COUNTIFS(B2:B8;"Steel";C2:C8;"Approved";E2:E8;"<="&J2); expect 2.

Change J2 to 2. J3 becomes 150 and J4 1. Restore J2 to 3. Concatenation combines the comparison operator and the numeric threshold while leaving the original quotes unchanged.

An unconstrained minimum, 60, is not a substitute for any of these selected minima. It belongs to a held plastic quote. Selection rules need to be explicit before a low value can be treated as relevant.

Create ZeroPriceControl separately, with Status and Price in A1:B1. Enter Accepted/0 in A2:B2, Accepted/25 in A3:B3 and Rejected/−5 in A4:B4.

In D2 enter =MINIFS(B2:B4;A2:A4;"Accepted"); expect 0. In D3 enter =COUNTIFS(A2:A4;"Accepted"); expect 2. This minimum is a genuine numeric zero among eligible records; the rejected negative value is not considered.

In D4 enter =COUNTIFS(A2:A4;"Expired"); expect 0. Zoho’s short MINIFS entry does not specify its native no-match return, so no zero or error output is asserted for an Expired minimum. Check the eligible count first and label a zero-count selection as having no matching records.

This approach assumes the Price column contains the complete numeric values shown. A count of matching statuses alone cannot guarantee that a larger imported price column is complete.

Do not replace excluded records with zero and then take MIN on a set of positive prices: the placeholder could become the minimum. Likewise, sorting one criteria column separately destroys record correspondence even if the range sizes still look right.

The cited entry does not fully define every wildcard, case-conversion, mixed-type, empty or error boundary. This guide uses exact labels, numeric comparisons and actual numeric candidates rather than transferring another application’s defaults.

COUNTIFS helps inspect eligibility and ties. MAXIFS selects the upper conditional extreme, and MIN supplies an unconditional lower bound. AND makes the row-level tie flags visible. A function returning the smallest price does not itself establish which quote should be accepted.