COUNTIF Function: Difference between revisions

From Planfix
Jump to: navigation, search
(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...")
 
 
(One intermediate revision by the same user not shown)
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