CountIf

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

Usage

CountIf(condition 1, ...)

condition 1 (required) The condition to test. If the condition is true, then the row will be counted.

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

Example

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 article helpful?

Anything else?

Our customer support team is here to help.

Contact Us