Formualizer Docs
ReferenceFunctionsMath Functions

AVERAGEIFS

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

Summary

AVERAGEIFS filters by all criteria pairs, then averages matching numeric values.

Remarks

  • The first argument is the average target range.
  • Criteria are supplied in (criteria_range, criteria) pairs.
  • If no numeric cells match, the function returns #DIV/0!.

Examples

Average with two criteria
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
10
Average over inline arrays
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
25
No matches returns divide-by-zero
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
#DIV/0!

FAQ

When does AVERAGEIFS return #DIV/0!?

It returns #DIV/0! when no matching numeric cells are available to average.

Do non-numeric matched cells count in the average?

No. Only numeric target cells contribute to sum and count.

Runtime metadata

Category

Math

Signature

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

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

Arity

min 3, max variadic

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTIONWINDOWEDSTREAM_OKPARALLEL_ARGSPARALLEL_CHUNKS

Source

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

AVERAGEIF

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

CEILING

CEILING: Rounds a number up to the nearest multiple of a significance.

On this page

SummaryRemarksExamplesRelated functionsFAQWhen does AVERAGEIFS return #DIV/0!?Do non-numeric matched cells count in the average?Runtime metadata