Forum Discussion

ianwuk's avatar
ianwuk
Iron Contributor
Feb 11, 2019

Help needed with how to count cells based on fill colour

Hi Everyone.

I have a table that looks like something like this:

 

 

 

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.

 

       

No RepliesBe the first to reply

Resources