DCOUNT

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

Syntax

=DCOUNT(DataRange, ColumnIndex, CriteriaRange)

Arguments

Name

Description

DataRange

Cell range, that containes the data to evaluate. The range must include the field labels.

ColumnIndex

Column label or index to count values in.

CriteriaRange

Specifies 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 Value

The counted amount of cells within the given parameters.

Example

Function

Result

Comment

=DCOUNT(A5:C9,2,A2:C3)

DSUM

2

Evaluates the number of valid age entries in “Berlin”.