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

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

The whole point is to mAke it automatic? Bosco !

Count cell Color ways :

1] By Using VBA (post #4 indicated)

- without helper column by create a module in VBE and writing code

- calculation by UDF (User Define Function)

2] By Using Getcell (Macro 4 function) (post #5 indicated)

- helper columns to find the color number by formula using Getcell function

- calculation by formula to count specified color number

3] By Using "Filter by Color" option in "Filter" (post #14 indicated)

- helper columns to fill number by hand after use "Filter by Color"

- calculation by formula to count specified color number

Remark : [1] and [2] automatic, [3] manual

Regards
Bosco
 
Back
Top