Formualizer Docs
ReferenceFunctionsDatabase Functions

DCOUNTA

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

Summary

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

Remarks

  • DCOUNTA counts both text and numeric non-empty values.
  • Criteria rows are OR-ed; criteria columns in the same row are AND-ed.
  • Blank cells are excluded from the count.

Examples

Count non-blank names where score > 80
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
2
Count all non-blank values in a field
Grid
CellValue
Formula
=
Result
Not evaluated yet.
Expected
2

FAQ

What is treated as blank in DCOUNTA?

Empty cells and empty strings are treated as blank; other value types are counted when their row matches criteria.

Runtime metadata

Category

Database

Signature

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

DCOUNT

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

DGET

DGET: Returns a single field value from the only record that matches criteria.

On this page

SummaryRemarksExamplesRelated functionsFAQWhat is treated as blank in DCOUNTA?Runtime metadata