COUNTIF Function: Difference between revisions

From Planfix
Jump to: navigation, search
 
Line 17: Line 17:


== Go To ==
== Go To ==
*[[Standard Formulas]]
*[[Standard functions]]
*[[Calculated fields]]
*[[Calculated fields]]
*[[Reports]]
*[[Reports]]

Latest revision as of 07:20, 18 July 2024

The COUNTIF function allows you to count the number of items in a list that meet a specific condition.

Format

COUNTIF(Repeating variable; Conditional expression)

Example

Counting the number of subtasks in a specific status:

COUNTIF({{Task.Subtasks}}; {{Task.Subtasks.Status}}="In Progress")

Result: the number of subtasks with the status "In Progress"


Go To