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 ; Business Intelligence & Analytics Professional
--------------------------------------------------------------------------------------------------------

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts