SUMIF Function: Difference between revisions

From Planfix
Jump to: navigation, search
(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/W8/0KpbVV.jpg
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/WT/4sVYkB.jpg
https://s.pfx.so/pf/0K/nxWe3v.jpg


DESCRIPTION:
DESCRIPTION:
Line 30: Line 30:
RESULT:
RESULT:


https://s.pfx.so/pf/eP/YWQZGE.jpg
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:

U5AKEN.jpg

FORMULA:

SUMIF({{Data tag.IRS Check.Price}}*{{Data tag.IRS Check.Amount}};{{Data tag.IRS Check.Expense type}}="Non-targeted")

nxWe3v.jpg

DESCRIPTION:

{{Data tag.IRS Check.Price}}*{{Data tag.IRS Check.Amount}} — calculated expression
{{Data tag.IRS Check.Expense type}}="Non-targeted" — condition

RESULT:

32RNeo.jpg

Go To