Skip to main content
Version: Streamsheets 2.5

DCOUNT

Counts all cells that contain a number within a cell range.

Syntax

=DCOUNT(DataRange, ColumnIndex, CriteriaRange)

Arguments

NameDescription
DataRangeCell range, that contains the data to evaluate. The range must include the field labels.
ColumnIndexColumn label or index to count values in.
CriteriaRangeSpecifies the conditions a row in cell range must fulfill. Must define at least one column with a label and a cell below which specifies the condition.

Return

The counted amount of cells within the given parameters.

Examples

FormulaResultComment
=DCOUNT(A5:C9,2,A2:C3) [object Object] [object Object]
2Evaluates the number of valid age entries in "Berlin".