mercredi 16 décembre 2020

Google Sheets: Calculate the number of coloured cells IF the check box is marked

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.

Sheet

Aucun commentaire:

Enregistrer un commentaire