Formualizer Docs
ReferenceFunctionsDatabase Functions

DSTDEV

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

Summary

DSTDEV computes standard deviation with the sample denominator (n - 1) after criteria filtering.

Remarks

  • Criteria rows represent OR branches; criteria columns in each row are combined with AND.
  • field is resolved by case-insensitive header text or 1-based column index; invalid field resolution returns #VALUE!.
  • At least two numeric values must match criteria, otherwise the result is #DIV/0!.

Examples

Sample stdev of units for East or West
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
7.847504911329036
Sample stdev of widget revenue
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
19756.85535031659

FAQ

Why does DSTDEV return #DIV/0! with one matching row?

DSTDEV uses sample statistics and needs at least two numeric matches for an n-1 denominator.

Runtime metadata

Category

Database

Signature

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

DPRODUCT

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

DSTDEVP

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

On this page

SummaryRemarksExamplesRelated functionsFAQWhy does DSTDEV return #DIV/0! with one matching row?Runtime metadata