SUMPRODUCT

SUMPRODUCT(array1 [,array2] [,array3][..])

Returns the sum of the product of one or more arrays of values.

array1	The first array.
array2	(Optional) The second array.
array3	(Optional) The third array.

REMARKS

* For an illustrated example refer to the page under Advanced Functions
* This function will use all the cells in a column reference.
* If the array arguments have different dimensions, then #VALUE! is returned.
* Any non numeric arguments are treated as zero.
* You can have a maximum of 255 arguments.
* You can use the COUNTIFS function to return the number of non blank cells that satisfies multiple conditions
* You can use the MMULT function to return the matrix product of two arrays.
* You can use the PRODUCT function to return the product of the numerical values.
* You can use the SUM function to return the total of the numerical values.
* You can use the SUMIFS function to return the total of the values that satisfies multiple conditions.
* This function has been available since Excel 1997.
* For the Microsoft documentation refer to support.microsoft.com
* For the Google documentation refer to support.google.com

	A	B	C
1	=SUMPRODUCT(1, 2, 3) = 6	1	6
2	=SUMPRODUCT(B1:B3) = 6	2	7
3	=SUMPRODUCT({1, 2, 3, 4}) = 10	3	8
4	=SUMPRODUCT(1, 2, 3, 4) = 24	4	9
5	=SUMPRODUCT(B1, B2, B3, B4) = 24	5	10
6	=SUMPRODUCT({1, 2}, {3, 4}) = 11
7	=SUMPRODUCT({1, 2}*{3, 4}) = 11
8	=SUMPRODUCT({1, 2, 3}, {4, 5, 6}) = 32
9	=SUMPRODUCT({1, 2, 3}*{4, 5, 6}) = 32
10	=SUMPRODUCT(B1:B2, C1:C2) = 20
11	=SUMPRODUCT(B1:C2, B3:C4) = 122
12	=SUMPRODUCT({1, 6;2, 7}, {3, 8;4, 9}) = 122
13	=SUMPRODUCT(MMULT({1, 2;3, 4}, {1, 2;3, 4})) = 54
14	=SUMPRODUCT({3, 4;8, 6;1, 9}, {2, 7;6, 7}) = #VALUE!
15	=SUMPRODUCT((A1:A20>=5)(A1:A20<=10)A1:A20)

1 - What is (1 + 2 + 3).
2 - This is equivalent to 1.
3 - What is (1 + 2 + 3 + 4).
4 - What is (1 * 2 * 3 * 4).
5 - This is equivalent to 4.
6 - What is (1*3) + (2*4).
7 - This is equivalent to 6.
9 - What is (1*4) + (2*5) + (3*6).
10 - This is equivalent to 9.
12 - What is (1*6) + (2*7).
13 - What is (1*3) + (2*4) + (6*8) + (7*9).
14 - This is equivalent to 13.