SUMIF Function
From Planfix
The SUMIF() function sums only the values of those rows from the field that meet the condition.
Format
- SUMIF(expression;condition)
Arguments:
- expression — mandatory, variable, or formula containing the final sum of several lines that meet the condition.
- condition — mandatory, from the IF function, only the condition is specified, without specifying the word IF and the positive and negative result.
Example
We display in the dynamic block the sum of the non-target expenses specified in the data tag:
FORMULA:
SUMIF({{Data tag.IRS Check.Price}}*{{Data tag.IRS Check.Amount}};{{Data tag.IRS Check.Expense type}}="Non-targeted")
DESCRIPTION:
{{Data tag.IRS Check.Price}}*{{Data tag.IRS Check.Amount}} — calculated expression
{{Data tag.IRS Check.Expense type}}="Non-targeted" — condition
{{Data tag.IRS Check.Expense type}}="Non-targeted" — condition
RESULT:
