MINIFS in Collabora Office: Find the Lowest Value Meeting Several Conditions

• Introduced: original Collabora release and launch date are not established by the sources reviewed.
• Availability: documented in Collabora Office 26.04 help, scoped to the desktop-help release.
• Platform scope: online and mobile deployments are not inferred from desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent calculations; no native Collabora test was performed.

=MINIFS(min_range;criteria_range1;criterion1;[criteria_range2;criterion2];...)

The first range supplies the values to minimize. Each following range is paired with a criterion. Collabora documents up to 127 range/criterion pairs, or 255 total arguments. All supplied ranges must have the same size; a mismatch has documented error err:502.

All criteria are combined with AND. For the ordinary text controls here, enable whole-cell matching and disable wildcard/regular-expression evaluation in the Calc calculation options. The same text expression can have a different matching scope when those settings change. Formulas use English names and semicolons.

Enter this complete register in A1:D7:

=MINIFS(C2:C7;A2:A7;"North";B2:B7;"Ready")

Expected result: 18, the smaller of 18 and 22. The North/Hold value 12 is excluded because it fails the Ready condition. The overall minimum 7 belongs to South, so it is excluded too.

With only the North condition, =MINIFS(C2:C7;A2:A7;"North") has expected result 12. Removing a criterion broadens selection; it does not merely shorten an equivalent formula.

=MINIFS(C2:C7;C2:C7;">=10";C2:C7;"<25")

Expected result: 12, from qualifying values 18, 12 and 22. The lower bound is included and the upper bound is excluded. Repeating the criteria range is intentional because each bound is a separate condition.

Adding B2:B7;"Ready" makes the expected result 18, since 12 belongs to a Hold record. The calculation range and a criteria range may refer to the same cells when the values themselves determine eligibility.

Put numeric 3 in F2:

=MINIFS(C2:C7;D2:D7;">="&F2)

Expected result: 18, from durations 18, 30 and 22 whose unit counts are at least three. Changing F2 to numeric 4 produces expected 22, from 30 and 22. Restore F2 to 3 after checking.

The operator is quoted, while the cell reference is outside the quotes and joined with &. Writing “>=F2” is not an equivalent reference to the threshold value.

Use COUNTIFS to check the same conditions before presenting an extreme for a group that may be absent:

=IF(COUNTIFS(A2:A7;"East";B2:B7;"Ready")=0;"No matching rows";MINIFS(C2:C7;A2:A7;"East";B2:B7;"Ready"))

Expected label: No matching rows. For North and Ready, the matching count is two and the corresponding minimum is 18. These controls use entirely numeric Minutes values, so matching rows also represent usable numeric observations.

The direct MINIFS page does not establish an exact raw no-match output. This guard describes the selected report value without claiming a particular raw fallback or a general formula-evaluation-order guarantee. A mixed-type result column needs an additional numeric-validity policy; counting matches alone does not certify its contents.

For North/Ready, MAXIFS gives expected 22 while MINIFS gives 18. Their difference is 4 minutes. The all-record span, 30-7=23, answers a different question.

Keep the range boundaries identical across the two summaries. Equal dimensions are necessary but not sufficient: sorting the Region column independently of Minutes can attach criteria to the wrong values without producing a size error.

Collabora documents text in the illustrated result range as ignored and logical TRUE/FALSE as 1/0. The examples here retain numeric result cells rather than extending those statements into a complete blank, imported-text or error matrix. A criterion referencing an empty cell is interpreted as numeric zero, while literal “=0” does not match empty cells under the documented criterion rule.

Some explanatory sentences in the official sample do not agree with their comparison operators. The examples above use the formal syntax, explicitly enumerated matching rows and independent arithmetic. Pattern evaluation, locale-sensitive criterion conversion and exact no-match behavior require their own controls.

• Collabora Office 26.04: MINIFS.
• Editorial testing standards.

The function-specific Collabora documentation was reviewed. Worked results are independent arithmetic or documented type-rule controls, not captured output from the application. Client-specific entry procedures and the boundaries identified above remain subject to native verification.