Sunday, 30 September 2012

Excel SumProduct Function To Find Count Based On Multiple Criteria

SumProduct Function To Find Count  Based  On Multiple Criteria

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

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts