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

    Populating how many project started by matching its name within any given month

    $C34 = Project1 B34 = 2009 E32 = 1 (january) =SUMPRODUCT(rProjectType=$C34)*(rActualStartDate>EOMONTH(DATE($B34,E$32-1,1),0)*(rActualStartDate<EOMONTH(DATE($B34,E$32,1),0))) I still get 0! What have I done wrong?
  2. T

    Populating how many project started by matching its name within any given month

    Hi Luke, it appears that the calculation still produces the same data. I wish to just take the rActualEndDate out of the equation. So instead I will just concentrate on one column rActualStartDate to see how many project was opened on a specific month, and this formula will be pasted in the...
  3. T

    Populating how many project started by matching its name within any given month

    Thanks a lot Luke! I will give this ago right away. Sorry for not responding any earlier, I was expecting an automated emails from chandoo.org when there is respond.
  4. T

    Populating how many project started by matching its name within any given month

    Hi guys, I'm honing my excel skills because I am required to pick up someone else's work on Excel. Naturally I am having some difficulties with it, in particular below code...
Back
Top