COUNTIF Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=COUNTIF Function |titlemode=append |keywords=planfix, function, COUNTIF |description=COUNTIF Function }} 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: <pre>COUNTIF({{Task.Subtasks}}; {{Task.Subtasks.Status}}="In Progress")</pre> '''Result''': the number of...") |
|||
Line 17: | Line 17: | ||
== Go To == | == Go To == | ||
*[[Standard | *[[Standard Formulas]] | ||
*[[Calculated fields]] | *[[Calculated fields]] | ||
*[[Reports]] | *[[Reports]] |
Revision as of 07:19, 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"