CountIf

 

Purpose:

Counts the number of values that comply with the condition. Use the function Distinct() when repeated values are only to be counted once.

Parameter:

Boolean         Expression for the comparison.

Boolean         (optional) TRUE: The values which were stored for the calculation are deleted after output. (default: TRUE). Please note that the stored calculation values are generally deleted for every (sub)table end. The second parameter only decides whether the values will be already deleted within the table.

Return value:

Number

Example:

CountIf(Customers.Region="EMEA")

CountIf(IsNull (Orders.OrderDate)) counts all values with empty fields.