# 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 all the numbers in a list, table or cell range.* You can use the SUM function to return the total of the numerical values in a list, table or cell range.* You can use the SUMIFS function to return the total of the values that satisfies multiple conditions.* 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.