COUNTIF

Counts the number of items that meet a specified condition to help analyze and summarize filtered data.

The COUNTIF function returns the number of items that meet a specified condition. It evaluates the given range against the defined criteria and counts only those values that satisfy the condition. This function is commonly used in reporting scenarios to determine how many entries fall within certain thresholds, ranges, or matching rules.

Syntax

COUNTIF(list, condition)

Arguments

list - List of values (Required).

condition - The condition to be evaluated (Required).

Example

COUNTIF([list],"condition")

In the example below, the COUNT measure is created using the COUNTIF function, which returns the number of items that meets the given condition from the ACME_Actuals measure.

The number of values from the four quarters that are greater than 150m is given in the COUNT measure

Applying COUNTIF function

Excel equivalent

COUNTIF