• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMPRODUCT formula gets SUM result instead of COUNT

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
 

Attachments

  • Case study_v2.xlsx
    15.2 KB · Views: 8
Back
Top