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)
 |
2 |
Evaluates the number of valid age entries in “Berlin”. |