Counts the number of rows in a table or group for which all given conditions are true.
CountIf(<condition 1>,<condition 2>…)
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
CountIf([Age] > 65)
- Count rows where Age is greater than 65
- Count rows where age is greater than 65 and Gender indicated is Female.
More About Aggregate Functions
If the column being aggregated is grouped, then the aggregate is computed for each group. For example, if the worksheet is grouped by the column [Year], then placing Sum([Revenue]) on the [Year] level computes the revenue for each year.
The results of aggregate functions can be referenced by lower levels. An example would be to create a Sum([Amount]) column as Total and then an [Amount] / [Total] column as Percentage. This converts each Amount value into a relative percentage value.