Sunday, 30 September 2012

Excel SUMPRODUCT Function Syntax and Examples

SUMPRODUCT Function:
SUMPRODUCT Returns the sum of the products of corresponding ranges or arrays. The SUMPRODUCT is a multipurpose function used to find the count and sum based on multiple criteria.
Sumproduct is a Most Powerful Function that can did the Job of the functions like Sum, SumIf, Sumifs, Count, Countif and Countifs.

Syntax:
=SUMPRODUCT (Array1, Array2, Array3, ...)

How Many Ways Sumproduct Works:
In how many ways we can use sumprodcuct  is explained in the following example:
Example:


------------------------------------------------------------------------------------------------------------------
Model 1:
=Sumproduct(A3:A11*B3:B11) =200



How Does It Works:


(2*2)+(4*2)+(8*1)+(10*2)+……=200



Note: 

The *(Asterisk) is used in the formula to find the sum of the products of given array values.

------------------------------------------------------------------------------------------------------------------Model 2 :
=Sumproduct(A3:A11+B3:B11) =121



How Does It Works:

(2+2)+(4+2)+(8+1)+(10+2)+……=121

Note: 
The +(Plus) is used in the formula to find the sum of the sums of given array values.
------------------------------------------------------------------------------------------------------------------
Model 3 :
=Sumproduct(A3:A11/B3:B11) =56




How Does It Works:
(2/2)+(4/2)+(8/1)+(10/2)+……=56

Note: 
The /(Division) is used in the formula to find the sum of the remainders of given array values.

NOTE:
If You have any ambiguity in understanding the above Sumproduct Function , Please comment about it.

Thanks.,
TAMATAM








No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts