karamaianguy
New Member
Helo guys,
Need you all expertise on this.
=SUMPRODUCT(($F$15:$F$23=$B6)*($F$15:$F$23=$B6)*($E$15:$E$23<=4),--(MONTH($D$15:$D$23)=VALUE(TEXT(K$5&"-2001","M"))),($E$15:$E$23))
Excel file attached.
PROBLEM
i get SUM result instead of COUNT which is my expected result.
Thanks
Need you all expertise on this.
=SUMPRODUCT(($F$15:$F$23=$B6)*($F$15:$F$23=$B6)*($E$15:$E$23<=4),--(MONTH($D$15:$D$23)=VALUE(TEXT(K$5&"-2001","M"))),($E$15:$E$23))
Excel file attached.
PROBLEM
i get SUM result instead of COUNT which is my expected result.
Thanks