Returns the number of cells in a specified table that match the specified condition.
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
Rule | Meaning |
---|---|
CountIf(PeopleTable,"=Male") | Counts the number of cells in the people table that equal Male. |
Range | Criteria | Result of the CountIf function |
---|---|---|
PeopleTable | "=Male" | 3 |
PeopleTable | "<50" | 6 (2 from the ID column and 4 from the Age column) |
PeopleTable
Member ID | Name | Age | Gender |
---|---|---|---|
42 | Dave Sharp | 25 | Male |
44 | Joe Bloggs | 37 | Male |
96 | Sandra Shield | 42 | Female |
107 | Thomas Knight | 21 | Male |
251 | Isabelle Jones | 56 | Female |