1 Reply Latest reply: Dec 3, 2013 10:01 AM by Rebecca Molstad RSS

    Count based on the cell's colour

      Hey everyone,

       

      I would like to find an expression that is able to count the number of cells in my table that are Red or Green.

       

      For example:

      Exemple QV.jpg

       

      For example, i have 4 differents types of meeting. Each of these meetings needs to be done once a week. When the meeting is proprely done, the cell is Green, if the meeting wasn't done or not yet done, the cell is red.

       

      I would like to know if it's possible to count the number of green cells that occurs before a particular date (ex.: date meeting).

       

      For example, if i select the 1st-december, i will see the number 3, because 3 meetings were done before this date.

       

      Thx a lot for your help !

       

      Best regards,

       

      Arnaud