Ignore cell value is the cell is grey?

Hello Everyone,

I am in need of a formula (I think a formula?) that will =SUM(K9:K33) but if any of the cells in this range are grey color (R 192, G 192, B 192) then I want them to be ignored and not counted.

So for example if every cell in the column from K9:K33 contained a number 1 and every cell had no fill apart from cell K16 (for example) that was grey color (R 192, G 192, B 192) (and also contained a one) the total for the column would be 24. There are 25 cells (all containing a 1) but one one of the cells is grey and therefore not counted...

Thank you in advance for any help,

Margate

Hello Martindwilson,
All of the cells start out with no color and then turn grey after a macro is run. Every cell in the column has a different macro that will turn it grey if the macro is activated.

Thank you for your help.

Margate

Ok, no problem, I did not know that. I will post the question on the Macro and VB section of the forum.

Thank you for your help

Margate