Returns the number of cells in a specified table that match the specified condition.
COUNTIF( [Table], [ Condition Expression] )
Counts the number of cells within a range that meet the given condition.
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
|COUNTIF(PeopleTable,"=Male")||Counts the number of cells in the people table that equal Male.|
Result of the COUNTIF function
|PeopleTable||"<50"||6 (2 from the ID column and 4 from the Age column)|