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

No comments:

Post a Comment

Hi User, Thank You for Visiting My Blog. Please Post Your Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts