Count IF Cell was grey and = 0 - Conditional formatting

[Donal28]

Hi All

I'm trying to count the number of cells in a range(K9:CB9) which are 0 where the cell is grey, only some of the cells in the range are grey and some are white. I am also using conditional formatting in the range where 1 = green, 2= yellow and 0 = Red so I suppose that means that I want to count the cells that were grey(now red(0) with the conditional formatting). I am using the formula below but it doesn't work. Is the conditional formatting complicating matters here?

=SUMIF(K9:CB9,0,"Gray")

Any help on this would be very much appreciated

Regards

Donal

 

[Joe4]

You cannot use the native Excel functions like SUM, SUMIF, or SUMPRODUCT based on formatting options, only cell values.

However, if these colors are based on Conditional Formatting, you should be able to use the same conditions you use for Conditional Formatting for the SUMIF or SUMPRODUCT formulas.