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