Counts the number of rows in a table or group for which all given conditions are true.


CountIf(condition 1, ...)

condition 1 (required) The condition to test. If the condition is true, then the row will be counted. Note: you can use operators in conditions.

condition 2+ (optional) Additional conditions to test. If multiple conditions are given, they must all be True in order to be counted.


CountIf([Age] > 65)
  • Count rows where Age is greater than 65
CountIf([Age] > 65, [Gender] = ”Female”)
  • Count rows where age is greater than 65 and Gender indicated is Female.


See Also

Was this page helpful?
Yes No