MAXIFS in Collabora Office: Find the Highest 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.

=MAXIFS(max_range;criteria_range1;criterion1;[criteria_range2;criterion2];...)

The first range contains values to maximize. Every subsequent criteria range must be paired with its criterion. Collabora documents up to 127 such pairs, or 255 total arguments, and requires all ranges to have the same size. A dimension mismatch has documented error err:502.

Conditions apply together with AND. These text examples assume whole-cell matching enabled and wildcard/regular-expression evaluation disabled in Calc’s calculation options. Those settings are material because a plain label can otherwise match part of a longer field. English function names and semicolon separators are shown.

Create A1:D7 exactly as follows:

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

Expected result: 22, the greater of 18 and 22. The overall maximum 30 belongs to South and fails the Region criterion. The formula therefore cannot be replaced with an unrestricted MAX call.

For South/Ready, the expected result is 30. Adding North and South as simultaneous equality criteria on the same Region range would mean AND, not an either-region selection.

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

Expected result: 22, from eligible values 18, 12 and 22. Changing the upper condition to “<22” gives expected 18. Using “<=22” includes 22 again and restores the expected maximum to 22.

Test values exactly at an endpoint before applying a reporting interval to a larger register. An inclusive versus exclusive bound can change the selected maximum even when the formulas differ by only one character.

Put numeric 3 in F2:

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

Expected result: 30, among values 18, 30 and 22. Adding the North condition gives expected 22. The threshold’s unit is Units, while the returned value is Minutes; keep both headings visible to avoid interpreting the result in the wrong unit.

The quoted comparison operator is joined to F2’s value. Putting the literal address inside the quoted string would not express the intended editable threshold.

Create H2:J4 with Region, Stage and Adjustment values:

=MAXIFS(J2:J4;H2:H4;"North";I2:I4;"Ready")

Expected result: -3, the greater North adjustment. The excluded South value -1 does not qualify, and zero is not inserted into this numeric subset as an extra candidate. The corresponding MINIFS control has expected -8.

Greatest signed value and greatest magnitude are separate questions. Among -8 and -3, the greatest signed value is -3; the greatest absolute magnitude is 8.

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

Expected label: No matching rows. The COUNTIFS guard uses exactly the same eligibility conditions as the maximum. For North/Ready it counts two and the corresponding maximum is 22.

This numeric dataset makes the match count a useful existence check. It does not prove that an arbitrary matched result column contains numbers. The direct MAXIFS source does not specify the raw no-match result, and this example does not claim a general lazy-evaluation rule for IF.

Identical dimensions do not establish correct row relationships. Sorting Stage or Region independently of Minutes can give a plausible but incorrect result. Keep whole records aligned before comparing selected extrema or adding criteria.

The official page’s first numeric sample conflicts with its own strict comparison and stated output. These examples use the formal definition and explicit row-by-row controls rather than copying that sample. Its documented TRUE/FALSE treatment is 1/0, but a full coercion or error matrix is outside this numeric scope.

Criteria depend on matching options and locale-sensitive conversion. An empty referenced criterion becomes numeric zero, while “=0” does not match empty cells according to the documented rule. Record these settings when comparing results across deployments.

• Collabora Office 26.04: MAXIFS.
• 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.