Count based on the cell's colour

[#1]

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:

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

[#2]

It is possible, but you will not be counting the number of Green or Red, you will be counting the number of meetings properly done before a particular date.  Same number, but very different ways of going about it.  What formula do you use to calculate the background colors?