Forum Discussion
ianwuk
Feb 11, 2019Iron Contributor
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