SUMPRODUCT(array1,array2[,array3,...]) Multiplies the corresponding elements in the specified
arrays and then sums the resulting products
e.g.
| dd | bb | Cc |
| 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 …
