COUNTIF Function

From Planfix
Revision as of 07:19, 18 July 2024 by Dmitri (talk | contribs) (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...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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

Retrieved from "http://planfix.com/help/index.php?title=COUNTIF_Function&oldid=21262"