Statistical

MINIFS function

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

Syntax

=MINIFS(min_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)
ArgumentUse
min_rangerequired
criteria_range1required, repeatable
criteria1required, repeatable
criteria_range2optional, repeatable
criteria2required, repeatable

Example

The smallest order in one region.

fx=MINIFS(E2:E7, C2:C7, "South")
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
8450

Result computed by the Sheets formula engine.

On live data

In Sheets, MINIFS 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 valueMAXIFSLargest value where all criteria matchMEDIANMiddle valueMINMinimum valuePERCENTILE.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