Formualizer Docs
ReferenceFunctionsDatabase Functions

DAVERAGE

DAVERAGE: Returns the arithmetic mean of values in a database field for matching records.

Summary

DAVERAGE applies criteria filtering first, then averages the numeric values in field.

Remarks

  • Criteria rows are OR conditions, while criteria columns in the same row are AND conditions.
  • field can be a case-insensitive header name or a 1-based column index; invalid field resolution returns #VALUE!.
  • If no numeric values match, the function returns #DIV/0!.

Examples

Average units for Gadget sales
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
29
Average revenue for West or South regions
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
97000

FAQ

What happens if criteria match rows but field values are non-numeric?

DAVERAGE skips non-numeric values and returns #DIV/0! if no numeric values remain after filtering.

Runtime metadata

Category

Database

Signature

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

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

Arity

min 3, max 1

Arguments

arg1

Any · Scalar

Caps

PUREREDUCTION

Source

crates/formualizer-eval/src/builtins/database.rs

Database Functions

Generated reference pages for Database functions.

DCOUNT

DCOUNT: Counts numeric cells in a database field for records matching criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat happens if criteria match rows but field values are non-numeric?Runtime metadata