Formualizer Docs
ReferenceFunctionsMath Functions

AVERAGEIF

AVERAGEIF: Returns the average of cells that satisfy a single criterion.

Summary

AVERAGEIF tests each cell in range, then averages matching values from average_range (or from range when average_range is omitted).

Remarks

  • Criteria support comparison operators and wildcard text patterns.
  • Non-numeric values in the averaged cells are ignored.
  • If no cells match, AVERAGEIF returns #DIV/0!.

Examples

Average values greater than a threshold
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
32.5
Average one range using criteria from another
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
15
No matches returns divide-by-zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!

FAQ

When does AVERAGEIF return #DIV/0!?

It returns #DIV/0! when no matching cells contribute numeric values.

If average_range is omitted, what gets averaged?

The function averages matching numeric cells from the criteria range itself.

Runtime metadata

Category

Math

Signature

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

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

Arity

min 2, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTIONWINDOWEDSTREAM_OKPARALLEL_ARGSPARALLEL_CHUNKS

Source

crates/formualizer-eval/src/builtins/math/criteria_aggregates.rs

AVERAGE

AVERAGE: Returns the arithmetic mean of numeric values across scalars and ranges.

AVERAGEIFS

AVERAGEIFS: Returns the average of cells that satisfy multiple criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does AVERAGEIF return #DIV/0!?If average_range is omitted, what gets averaged?Runtime metadata