Home Search

DriveWorks Pro 19
CountIF

Send Feedback

CountIf

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

Syntax

CountIf([Table], [Condition Expression], [Ignore Whitespace] )

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

Ignore Whitespace (optional) is True to ignore leading/trailing whitespace characters in text strings, in the condition, otherwise False.

Examples

Rule

Meaning
CountIf(PeopleTable,"=Male ", True)Counts the number of cells in the people table that equal Male. Will remove the whitespace, before the last ".

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