ReferenceFunctionsDatabase Functions

DCOUNT

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

Summary

DCOUNT ignores non-numeric values in the selected field even when the row itself matches.

Remarks

Criteria rows are ORed, and criteria columns inside a single row are ANDed.
field header lookup is case-insensitive, and numeric field uses 1-based indexing; unresolved headers or invalid indexes return #VALUE!.
Only numeric field values contribute to the count.

Examples

Count numeric revenue entries in East region

Grid

Cell	Value

Formula

=

Result

Not evaluated yet.

Expected

2

FAQ

Does DCOUNT count text values that look like numbers?

Only values resolved as numeric in the target field are counted; true non-numeric text is ignored.

Runtime metadata

Category

Database

Signature

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

DAVERAGE

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

DCOUNTA

DCOUNTA: Counts non-blank values in a database field for records matching criteria.

On this page

Summary Remarks Examples Related functions FAQ Does DCOUNT count text values that look like numbers?Runtime metadata