SUMPRODUCT(array1,array2,array3, ...) returns the sum of the products of corresponding array components : SUMPRODUCT « Math Trigonometry functions « Microsoft Office Excel 2007 Tutorial

1. Microsoft Office Excel 2007 Tutorial
2. Math Trigonometry functions
3. SUMPRODUCT

Input the formula: =SUMPRODUCT(A2:B4, C2:D4)

20.53.SUMPRODUCT
	20.53.1.	SUMPRODUCT(array1,array2,array3, ...) returns the sum of the products of corresponding array components