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

    Countif (For a specific colour + a specific year + Specific month)

    I didn't make any changes to your file..
  2. K

    Countif (For a specific colour + a specific year + Specific month)

    The whole point is to mAke it automatic? Bosco !
  3. K

    Countif (For a specific colour + a specific year + Specific month)

    Ad why does it stop working all the time?
  4. K

    Countif (For a specific colour + a specific year + Specific month)

    Limitation : The changes do not automatically reflect on the tale on the right :(
  5. K

    Countif (For a specific colour + a specific year + Specific month)

    Is it possible to get the result without the table on the right ? will be better >>>>>>>> Thanks anyway Bosco !
  6. K

    Countif (For a specific colour + a specific year + Specific month)

    Thanks ! will update if it works for me
  7. K

    Countif (For a specific colour + a specific year + Specific month)

    Bosco, Can you send to me a working example - would be really useful ! Thanks
  8. K

    Countif (For a specific colour + a specific year + Specific month)

    Ok , will check ! thanks for your help
  9. K

    Countif (For a specific colour + a specific year + Specific month)

    If you see my sample - you will understand clearly - what my requirement is !
  10. K

    Countif (For a specific colour + a specific year + Specific month)

    I cannot have the colour code in my file as shown in the file (from your link)
  11. K

    Countif (For a specific colour + a specific year + Specific month)

    Ok ! I shall try and get back to you in few days ! thanks for your help chihiro !
  12. K

    Countif (For a specific colour + a specific year + Specific month)

    I am able to get the cell colour and count seperately. But, not together !
  13. K

    Countif (For a specific colour + a specific year + Specific month)

    Thanks for the response .. No logic .. ! Once the issue is solved... colours are changed Regards, Kiki
  14. K

    Countif (For a specific colour + a specific year + Specific month)

    Hello All, I would like to count for red colour ,Jan, 2016 ( FOR EXAMPLE). Tried using sumproduct (worked only for Jan, 2016). didnt work for the colour. =SUMPRODUCT((YEAR(RANGE)=2016)*(MONTH(RANGE)=12)) Please find the attached sample for better understanding. Note : I'm not using...
Back
Top