Home

Help needed with how to count cells based on fill colour

ianwuk
Contributor

Hi Everyone.

I have a table that looks like something like this:

 

 

Data.PNG

 

How can I make it so that:

1 - Cell A10 counts only the cells that contains a date - so the total should be 3).


2 - Cell B10 counts only the green cells (or any other colour I choose) - so the total should be 2.

3 - Cell C10 counts only the cells that contain a text value I specify (e.g. 'C') so the total should be 2.

For that, I have this formula, is it correct?

=COUNTIF(C3:C5,"*C*")

 

4 - In cell D10 (not shown) it counts the cells that are orange or green from column A.  So the total returned is 2.

Many thanks for your help.