Formualizer Docs
ReferenceFunctionsDatabase Functions

DVARP

DVARP: Returns the population variance of a database field for records matching criteria.

Summary

DVARP computes variance with the population denominator (n) over filtered records.

Remarks

  • Criteria rows are OR branches; populated criteria cells in the same row are combined with AND.
  • field accepts case-insensitive header text or 1-based index; bad field/header resolution returns #VALUE!.
  • At least one numeric value must match criteria, otherwise the function returns #DIV/0!.

Examples

Population variance of units for East or West
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
46.1875
Population variance of widget revenue
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
260222222.2222222

FAQ

Why can DVARP return a value with only one matched row?

Population variance divides by n, so one numeric match yields a defined result instead of #DIV/0!.

Runtime metadata

Category

Database

Signature

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

DVAR

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

Date & Time Functions

Generated reference pages for Date & Time functions.

On this page

SummaryRemarksExamplesRelated functionsFAQWhy can DVARP return a value with only one matched row?Runtime metadata