Hi bohi

Since only cells with 1 will turn Gray, you might as well just count all the cells with 1's.

Good morning SunnyKow,

I guess I should have included more detail.  If D1 = 1, then A1 is Gray.  If E1 = 2, then A1 is yellow and if F1 = 3, then A1 is Strikethrough.  My intention was to count just the D1 = 1, then A1 is Gray conditional format.  Column A shows current progress on a specific task which is updated daily sometimes hourly.

Hi

Are all the colored cells in column A?

Yes but i only interested in counting the Conditional Formatted Gray Cells.  Once they turn Yellow or Strikethrough, it's out og my hands.  I am aware of the formula to count all 1's, but they all have 1's once they are entered into the spreadsheet.

Can I say that if D is 1 it turns grey but if E also have a 2, it will override with yellow?

So you may have D=1 and E=2 and possibly F=3 all filled in a single row. 

You need to find Grey cells with  D=1, E=blank and F = blank. Am I correct?

Can you see if this is what you want?

SunnyKow,

Attached is an update to your spreadsheet showing how I have my formulas. Condition 2 overrides condition 1 and condition 3 overrides condition 2

SunnyKow,

Thank you for your help on this issue.  Once I started communicating back and forth with you, it occured to me that I was going about this in the wrong way.  Instead of trying to figure our how to write a formula for a Conditional Format, why not write a formula for a regular issue.  My solution is

=SUMIFS(Sheet1!$F:$F,Sheet1!$W:$W,"1",Sheet1!$X:$X"",Sheet1!$Y:$Y,"")  This tells me qty of $F:$F if $W:$W =1 and $X:$X is blank and $Y:$Y is blank.

Thank you for your inspiration

Glad to be able to help out