BET: Microsoft Excel Functions

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

REMARKS

		If the array arguments have different dimensions, then #VALUE! is returned.
		Any non numeric arguments are treated as zero.
		Using the SUM() function with arrays (see examples 8 and 11) can often provide a more general solution than using this function.
		You can have a maximum of 30 arguments.
		Example 1 - What is (1 + 2 + 3).
		Example 2 - This is equivalent to Example 1.
		Example 3 - What is (1 + 2 + 3 + 4).
		Example 4 - What is (1 * 2 * 3 * 4).
		Example 5 - This is equivalent to Example 4.
		Example 6 - What is (13) + (24).
		Example 7 - This is equivalent to Example 6.
		Example 8 - Array Formula. This is equivalent to Example 7.
		Example 9 - What is (14) + (25) + (3*6).
		Example 10 - This is equivalent to Example 9.
		Example 11 - Array Formula. This is equivalent to Example 9.
		Example 12 - What is (16) + (27).
		Example 13 - What is (13) + (24) + (68) + (79).
		Example 14 - This is equivalent to Example 13.
		For more working examples please refer to the SUMPRODUCT Function page.

EXAMPLES