SUMIF Function: Difference between revisions
From Planfix
(Created page with "{{#seo: |title=SUMIF Function |titlemode=append |keywords=planfix, function, SUMIF, sum if |description=SUMIF Function }} 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,...") |
No edit summary |
||
| Line 17: | Line 17: | ||
We display in the dynamic block the sum of the non-target expenses specified in the data tag: | We display in the dynamic block the sum of the non-target expenses specified in the data tag: | ||
https://s.pfx.so/pf/ | https://s.pfx.so/pf/Dc/U5AKEN.jpg | ||
FORMULA: | FORMULA: | ||
| Line 23: | Line 23: | ||
<div style="display: block; padding: 1em; margin: 0 0 10px; font-size: 13px; line-height: 1.65; color: black; word-wrap: break-word; background-color: #f9f9f9; border: 1px solid #ddd; border-radius: 4px;">SUMIF(<span style="color:green;"><nowiki>{{Data tag.IRS Check.Price}}*{{Data tag.IRS Check.Amount}}</nowiki></span>;<span style="color:blue;"><nowiki>{{Data tag.IRS Check.Expense type}}="Non-targeted"</nowiki></span>)</div> | <div style="display: block; padding: 1em; margin: 0 0 10px; font-size: 13px; line-height: 1.65; color: black; word-wrap: break-word; background-color: #f9f9f9; border: 1px solid #ddd; border-radius: 4px;">SUMIF(<span style="color:green;"><nowiki>{{Data tag.IRS Check.Price}}*{{Data tag.IRS Check.Amount}}</nowiki></span>;<span style="color:blue;"><nowiki>{{Data tag.IRS Check.Expense type}}="Non-targeted"</nowiki></span>)</div> | ||
https://s.pfx.so/pf/ | https://s.pfx.so/pf/0K/nxWe3v.jpg | ||
DESCRIPTION: | DESCRIPTION: | ||
| Line 30: | Line 30: | ||
RESULT: | RESULT: | ||
https://s.pfx.so/pf/ | https://s.pfx.so/pf/5M/32RNeo.jpg | ||
== Go To == | == Go To == | ||
*[[Standard functions | Standard operators and Planfix functions]] | *[[Standard functions | Standard operators and Planfix functions]] | ||
Latest revision as of 09:02, 21 February 2024
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:
