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,