SUMPRODUCT

SUMPRODUCT(array1,array2[,array3,...]) Multiplies the corresponding elements in the specified

arrays and then sums the resulting products

e.g.

dd	bb	Cc
1	1	1
0	2	2
3	5	3
4	8	4
5	5	5
6	6	6
7	7	7
8	8	8
9	9	9
0	10	10

Let’s say we have three ranges dd, bb, cc as shown above in table.

Let say we have following formula

=SUMPRODUCT(--(dd=bb),--(cc))

Let’s walk through row by row

Row 1

=SUMPRODUCT(--(1=1),--(1)) : (1=1) Equals (=) will return 1

=SUMPRODUCT(--(1),--(1)) : 1*1 = 1

Row 2

=SUMPRODUCT(--(0=2),--(1)) : (0=2) Equals (=) will return 0

=SUMPRODUCT(--(0),--(2)) : 0*2 = 0

And so on …