SumIf
Adds up the sums of a set, after checking a condition against a coordinated set.
Syntax
SumIf(set1, condition, set2)SommeSi(set1, condition, set2)
set1 first set against which the condition is checked
condition = the condition that determines which values to count
set2 = set on which the conditional summation is performed
Remarks
The condition is understood as a string, starting with a comparison operator (=, <, >, <=, >= or <>), followed by a literal value.
If the literal value starts with a ' or ", it will be understood as a string, and string comparisons will be performed. Otherwise, it will be understood as a numerical value.
If no operator is specified, the "equal to" operator will be used.
For an easier way to count only the number of values equal to a specific value, see CountIf.
Examples
SumIf(List(1, 2, 1), "=1", List(10, 20, 30)) = 40