Apple Numbers MAXIFS: Maximum by Multiple Criteria and No-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 MAXIFS reference. Examples checked by independent typed-value and selection models; no native Numbers test.

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

Supply the result range, a criteria range and its condition. Further criteria-range/condition pairs are optional. Apple’s reference requires every criteria range to have the same size as the result range; mismatched sizes return an error. It explicitly returns 0 when no criteria match.

The result values must not mix date/time or duration types with other types. Referenced text or booleans are permitted by the input description, but direct text/boolean result arguments are not. Text criteria such as “East” remain valid conditions; that restriction does not prohibit them.

The examples use complete numeric result values and aligned criteria. They do not infer every missing-value or coercion rule from the type description.

Create a Numbers table named Orders, with ten columns A:J and ten rows including one header row. Put Order ID, Region, Status, Amount and Units in A1:E1. Enter:

Use G for labels and H for results. Keep I as a spacer and J for criterion controls.

H4 includes R108 with exactly nine units. H5 excludes it, and the only East order above nine units is Open, so no record meets all three conditions. H8 answers the unfiltered question; the North amount of 300 does not belong in the East summary.

Put East in J2 and the number 8 in J3. Enter this in H10:

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

Expect 175. Change only J3 to 10; expect 0, because there is no paid East record with at least ten units. Restore J3 to 8 afterward. The other H formulas keep their original hard-coded criteria.

The concatenation joins the comparison operator to the threshold value. Apple’s conditions guide covers these comparison-based functions.

Create a separate RegionSummary table with five columns and five rows. Put Region, Paid matches, Maximum, Display and Tied winners in A1:E1. Enter East, West, North, South in A2:A5.

Enter these formulas in row 2, then fill B2:E2 through row 5:

B2: =COUNTIFS(Orders::B$2:B$9,A2,Orders::C$2:C$9,"Paid")
C2: =MAXIFS(Orders::D$2:D$9,Orders::B$2:B$9,A2,Orders::C$2:C$9,"Paid")
D2: =IF(B2=0,"No matches",C2)
E2: =COUNTIFS(Orders::B$2:B$9,A2,Orders::C$2:C$9,"Paid",Orders::D$2:D$9,C2)

The B2:/C2: prefixes identify destination cells; do not type those prefixes into the formula editor.

The COUNTIFS companion separates absence from a numeric maximum, and the final count shows that two East orders tie. MAXIFS alone does not choose which tied order should be shown first.

In a separate two-column ZeroCheck table with five rows, enter:

The equal maximum results have different causes: no South record versus one East record whose amount is actually zero.

For a negative-value control, create Adjustments, with four columns and five rows. Put East,-40; East,-10; West,-80; West,-20 in A2:B5, one pair per row. Enter =MAXIFS(B2:B5,A2:A5,"East") in D2; expect −10. Enter the same formula with “North” in D3; expect 0 for no match. Do not rank the missing group’s zero as though it were an observed adjustment.

Equal sizes alone are insufficient if rows refer to different records. Keep every criteria range aligned with its amount. The reference gives a generic mismatched-range error without establishing every exact error token or all blank/error boundaries.

Follow Numbers’ table-reference rules and the document’s regional separators. MINIFS selects the smallest qualifying amount; MAX has no criteria, and SUMIFS totals the qualifying amounts instead of selecting one.