Hello.
I need help counting cells that contain colours using a formula.
I have data that looks like this:
How can I count green cells in both columns B and C and display the total in cell B7? (so it should be 1).
How can I count the green or orange cells in column B and put the total in A7 (so it should be 2).
Many thanks.
I need help counting cells that contain colours using a formula.
I have data that looks like this:

How can I count green cells in both columns B and C and display the total in cell B7? (so it should be 1).
How can I count the green or orange cells in column B and put the total in A7 (so it should be 2).
Many thanks.