Sunday, 30 September 2012

How to Find the Count based on Multiple Criteria with Excel SumProduct Function

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, ...)
Example:


------------------------------------------------------------------------------------------------------------

Declaration Method 1:


------------------------------------------------------------------------------------------------------------
Declaration Method 2:



Here :
In Sumproduct Function we have taken three arrays and each array should satisfy a particular criteria, then returns Count.

We can use (*) or (--) symbols in between arrays.In the above arrays there is no Numerical Data Array.



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