Formualizer Docs
ReferenceFunctionsStatistics Functions

MAXIFS

MAXIFS: Returns the maximum numeric value in a range that meets all criteria.

Summary

MAXIFS applies one or more (criteria_range, criteria) pairs and returns the largest 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

Maximum value for one condition
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
15
Maximum value with two criteria
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
90

FAQ

What does MAXIFS return when no rows match all criteria?

It returns 0 when no numeric target cells satisfy every criterion.

Runtime metadata

Category

Statistics

Signature

MAXIFS(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

LOGNORM.INV

LOGNORM.INV: Returns the positive value `x` whose log-normal cumulative probability is `probability`.

MEDIAN

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhat does MAXIFS return when no rows match all criteria?Runtime metadata