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, 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 !