Formualizer Docs
ReferenceFunctionsDatabase Functions

DPRODUCT

DPRODUCT: Multiplies values in a database field for records that satisfy criteria.

Summary

DPRODUCT filters the database first, then returns the product of numeric values in field.

Remarks

  • Criteria rows are evaluated as OR alternatives; criteria columns in one row are AND constraints.
  • field resolves via case-insensitive header text or 1-based column index; unresolved field references return #VALUE!.
  • If no numeric values match, this implementation returns 0.

Examples

Product of units in North or South
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
486
Product of units for East or West by index field
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
196416

FAQ

What result does DPRODUCT return if no numeric records match?

This implementation returns 0 when no numeric field values remain after criteria filtering.

Runtime metadata

Category

Database

Signature

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

DMIN

DMIN: Returns the smallest value in a database field for records matching criteria.

DSTDEV

DSTDEV: Returns the sample standard deviation of a database field for matching records.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat result does DPRODUCT return if no numeric records match?Runtime metadata