## 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

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

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

Thanks,TAMATAM