COUNTIF

The COUNTIF function returns the count of values that match a specified condition.

Syntax

COUNTIF(list, condition)

Arguments

• list: The list of values to evaluate.

• condition: The condition used to filter the values.

Return value

Returns the number of values that satisfy the given condition.

Example

COUNTIF([[2024.Plan_Variance %], [2025.Plan_Variance %], [2026.Plan_Variance %]], ">0")

Returns the count of Plan Variance % values across 2024, 2025, and 2026 that are greater than 0.

Excel equivalent

COUNTIF