SUMIF2
SUMIF2 is similar to Microsoft Excel's SUMIF formula. The difference is that in SUMIF2, you can define the operator explicitly.
Syntax
=SUMIF2(comparison_range,"comparison_operator",comparison_value, value_range)
Example
For each value in the first range which matches the comparison value, it sums the equivalent values in the second range.
Sumif2(a1:a5,"=",1,b1:b5)
With this sample data, this formula returns 58:
The comparison value specified in the formula is 1. The comparison value is in Row 3 and in Row 5 of the first range (A1:A5). The formula sums the equivalent values in the second range (B1:B5). That is, 47+11=58.
| A | B | |
|---|---|---|
| Row 1 | 72 | 108 |
| Row 2 | 54 | 71 |
| Row 3 | 1 | 47 |
| Row 4 | 92 | 88 |
| Row 5 | 1 | 11 |