DEFINITION:- The Sumproduct Function Multiplies Ranges Or Arrays Together And Returns The Sum Of Products. The main purpose of Sumproduct is to multiply the array or range and then add those value and return the sum of the particulars.
SYNTAX:- =SUMPRODUCT (array1, array2, …)
EXAMPLE:-
Suppose You Have A Few Items In Stock As Per The Image Below. If You Want To Know How Much The Total Price According To The Quantity, You Should Use The Sumproduct Formula.
Explanation: The Sumproduct Function Performs This Calculation: Quantity * Price (2 * 20000) + (3* 15000) + (5 * 12000) + (4 * 9000) + (5*500) = 183500
VALIDATION:- The Ranges Must Have The Same Dimensions Or Excel Will Display The #Value! Error.
SINGLE ARRAY:- If You Supply A Single Range Example:- H2:H7, The Sumproduct Function Produces The Exact Same Result As The Sum Function Does.
