Returns the number of cells in a specified column of a specified table that match the specified condition.
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
|DCOUNT(PeopleTable,4,"=Male")||Counts the number of cells in the fourth column of the people table that equal Male.|
|DCOUNT(PeopleTable,2,"<>""")||Counts the number of cells in the second column of the people table that does not equal blank ("").|
|DCOUNT(PeopleTable,3,">30")||Counts the number of cells in the third column of the people table where the value is greater than 30|
Result of the COUNTIF function