Statistical

MAXIFS function

Largest value where all criteria match. MAXIFS works in Sheets with the usual arguments and results, on cells and on live data from the tools you connect.

Syntax

=MAXIFS(max_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
ArgumentUse
max_rangerequired
criteria_range1required, repeatable
criteria1required, repeatable
criteria_range2optional, repeatable
criteria2required, repeatable

Example

The largest order still open.

fx=MAXIFS(E2:E7, D2:D7, "Open")
ABCDEF
1OrderCustomerRegionStatusAmountDate
2#1001Acme LtdNorthPaid12002026-01-14
3#1002Blue FoxSouthOpen4502026-01-20
4#1003Acme LtdNorthPaid9802026-02-03
5#1004Cedar & CoEastOverdue23002026-02-11
6#1005Blue FoxSouthPaid6102026-03-02
7#1006Delta BVWestOpen17502026-03-09
81,750

Result computed by the Sheets formula engine.

On live data

In Sheets, MAXIFS sits next to live data from a connected tool: =data.orders.sum(total) totals a table, =list.orders(customer) spills a column's distinct values, and a linked table column such as table.orders[Total] is a range any function accepts.

See the integrations

Try it in a free calculator

Box and whisker plot makerPaste your numbers to draw a box and whisker plot with the minimum, quartiles, median, maximum, IQR and outliers, each worked out by a spreadsheet formula you can copy..

More statistical functions

AVERAGEMean of valuesAVERAGEIFMean where one criterion matchesAVERAGEIFSConditional meanCOUNTCount numbersCOUNTACount non-emptyCOUNTIFCount where one criterion matchesCOUNTIFSConditional countMAXMaximum valueMEDIANMiddle valueMINMinimum valueMINIFSSmallest value where all criteria matchPERCENTILE.INCThe k-th percentile, k from 0 to 1

All 147 statistical functions →

Spreadsheet formulas on live business data

Sheets evaluates 491 spreadsheet functions, on cells and on data read live from your tools.

See the integrations