I am trying to calculate the number of coloured cells in a column where the check box is also marked.
For example, in column F, there are 2 green cells in rows with marked check boxes. I have failed to work out a formula that would help me do this. I am using the function by colour add-on to count number of coloured cells.
Any help would be greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire