SUMPRODUCT Sum The Return Value True And False. True = 1 And False = 0 . LEN Function Check The Len For All Cell And Return The Length As Array. For More Detail Please Check Image Below.
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 Exampl...