DriveWorks Solo 15: DCount [send feedback...]

Syntax

DCOUNT( [Table], [ Column], [ Condition] )

Counts all the cells in the given table's column, that comply with the specified condition.

Range is the table within which the cells are to be counted

Criteria is the search condition that when matched will count the cells

Examples

Rule

Meaning
DCOUNT(PeopleTable,4,"=Male")Counts the number of cells in the fourth column of the people table that equal Male.

Example Outcomes

Table

Column

Criteria

Result of the COUNTIF function

PeopleTable4"=Male"3
PeopleTable3"<50"4

Sample Data

People Table

Member IDNameAgeGender
42Dave Sharp25Male
44Joe Bloggs37Male
96Sandra Shield42Female
107Thomas Knight21Male
251Isabelle Jones56Female

Table of Contents