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.

 

       

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
14 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
23 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
W10-1903 UNC path failing 0x80070043
kurgan in Windows Insider Program on
80 Replies