DriveWorks Pro 17: CountIF [send feedback...]

CountIf

Returns the number of cells in a specified table that match the specified condition.

Syntax

CountIf([Table], [Condition Expression] )

Where:

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

Condition Expression is the search condition that when matched will count the cells

Examples

Rule

Meaning
CountIf(PeopleTable,"=Male")Counts the number of cells in the people table that equal Male.

Example Outcomes

Range

Criteria

Result of the CountIf function

PeopleTable"=Male"3
PeopleTable"<50"6 (2 from the ID column and 4 from the Age column)

Sample Data

PeopleTable

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

Table of Contents