Formualizer Docs
ReferenceFunctionsDatabase Functions

DSUM

DSUM: Sums values in a database field for records that match criteria.

Summary

DSUM filters database rows using a criteria range, then adds the selected field values.

Remarks

  • Criteria rows are evaluated with OR semantics; populated criteria columns within one row are ANDed.
  • field resolves by case-insensitive header text or 1-based column index; unknown headers and out-of-range indexes return #VALUE!.
  • Non-numeric values in the target field are ignored unless they coerce to numbers.

Examples

Sum revenue for East or West regions
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
415500
Sum revenue by field index with numeric criteria
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
488500

FAQ

How are multiple criteria rows interpreted in DSUM?

Each criteria row is an OR branch, while multiple populated criteria columns in one row are combined with AND.

Runtime metadata

Category

Database

Signature

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

DSTDEVP

DSTDEVP: Returns the population standard deviation of a database field for matching records.

DVAR

DVAR: Returns the sample variance of a database field for records matching criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are multiple criteria rows interpreted in DSUM?Runtime metadata