Formualizer Docs
ReferenceFunctionsStatistics Functions

MINIFS

MINIFS: Returns the minimum numeric value in a range that meets all criteria.

Summary

MINIFS evaluates one or more (criteria_range, criteria) pairs and returns the smallest matching numeric value.

Remarks

  • Arguments must be target_range plus one or more criteria pairs.
  • Criteria are combined with logical AND.
  • Returns 0 when no cells satisfy all criteria.
  • Non-numeric cells in target_range are ignored.

Examples

Minimum value for one condition
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
10
Minimum value with two criteria
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
70

FAQ

How does MINIFS treat non-numeric target cells?

Non-numeric target cells are ignored; only numeric matches are eligible.

Runtime metadata

Category

Statistics

Signature

MINIFS(arg1, arg2, ... argN: Any)

This function accepts a repeating argument pattern (min args: 3).

Arity

min 3, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTION

Source

crates/formualizer-eval/src/builtins/stats/mod.rs

MEDIAN

MEDIAN: Returns the middle value of a numeric data set.

MODE.MULT

MODE.MULT: Returns all modal values as a vertical array.

On this page

SummaryRemarksExamplesRelated functionsFAQHow does MINIFS treat non-numeric target cells?Runtime metadata