SumIf
The SumIf function adds the numbers in a column if all the conditions are true for that row.
Syntax
SumIf(field, condition 1, [condition 2], ...)
Function arguments:
- field (required) - The column of numbers to add together. Null values are skipped.
- condition 1 (required) - The logical condition that returns a result that is either True or False. If the condition is True, the number on the corresponding row is added to the sum. Note: you can use operators in conditions.
- condition 2 + (optional) - Additional conditions can be added after the first condition.
In the case of multiple conditions the "AND" logical operator is used by default. In order to use an "OR" operator the conditions should be encapsulated in a single condition chained by an explicit "OR."
Examples
SumIf([Sales], [State] = "TX" )
Returns the sum values in the Sales column if the State column value is TX
.
SumIf([Sales], [State] = "TX" OR [State] = "CA")
Returns the sum of values in the Sales column if the State column value is TX
or CA
.
SumIf([Sales], [State] = "TX", [CustomerID] = "1234" )
Returns the sum of values in the Sales column if the State column value is TX
and the CustomID column value is 1234
.
SumIf([Sales], [State] = [list-control-state])
Returns the sum of values in the Sales column if the State column value matches the value selected in the list-control-state control element.
Updated about 10 hours ago