• 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.

Search results

  1. A

    Please help me in COUNTIFS and SUMPRODUCT [SOLVED]

    Hi bhasoriya, Did you try pressing F2 and then ctrl+shift+enter.
  2. A

    Please help me in COUNTIFS and SUMPRODUCT [SOLVED]

    I am a newbie in this area. I answering this so that I can know whether this is a valid answer to this problem. I done this with array formula. COUNT(IF(((MONTH(LA!$B$18:$B$44)=MONTH(DATEVALUE("01-"&$A$1)))*(LA!$C$18:$C$44=A4)),VALUE(LA!$D$18:$D$44)))
Back
Top