SUMIF2

SUMIF2 is similar to Microsoft Excel's SUMIF formula. The difference is that in SUMIF2, you can define the operator explicitly.

SUMIF2 has this 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:


	A	B
Row 1	72	108
Row 2	54	71
Row 3	1	47
Row 4	92	88
Row 5	1	11

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.