MINIF

Returns the minimum value among the cells that meet a specified condition.

Syntax

MINIF(range, criteria)

Arguments

• range: The range of cells to consider.
• criteria: The condition that defines which cells to consider.

Criteria

Simple Expressions

• >,<,>=,<=,==,!=,===,!==: Can be used in critiera such as <8 , !=12 etc

Special Expressions

• BETWEEN(lower,upper): Using BETWEEN(10,20) will match from 11 to 19
• IN(a,b,c..): Using IN(10,11,21,30) will match the supplied list of numbers
• NOT(a,b,c..): Using NOT(10,11,21,30) will match everthing other than the supplied list of numbers

Compound expressions

Complex expressions such as the one below can also be used

• >8 && (!=12 && !=13): Match all numbers that is great than 8 and is not 12 and 13

Example

MINIF(A1:A10, ">20") → Returns the smallest value in A1:A10 that is greater than 20
MINIF(C@CURRREC!A10, ">0") → Returns the smallest value in children's A10 that is greater than 0

A common use is finding the earliest date across a set of child records while excluding ones that haven't happened yet (stored as 0):

IFERROR(MINIF(C@CURRREC!N@Invoice!{{Date Invoice Funded}}, ">0"), 0)

Plain MIN can't do this on its own — an unfunded invoice's Date Invoice Funded is 0, and 0 would always win as the minimum. MINIF excludes it by requiring the match condition first.

Usage Notes:

• Returns undefined if no cell in range satisfies criteria, or if range is empty or not an array. Wrap with IFERROR.
• Null or undefined entries in range are skipped, not treated as 0.
• See also MAXBY/MINBY, which return the whole matching object from an array of objects rather than a bare minimum/maximum value.