Countif where cells contain a colour or colours

[colinheslop1984]

Is there a way to conduct a countif function where it only counts the cells that contain a colour or counts all cells but deducts the number of cells containing a particular colour, grey for example.

ie in cell e19:f19 (merged cells) I want to count the number of cells that do not have the fill colour grey from range e8:f17.

Also in some instances cells may be merged, if this affects it, I need a workaround.

Any ideas would be appreciated

 

[James006]

Is it sarcasm?

Absolutely NOT ... !!!

Very few people would answer as clearly as you did ... with the essential infos ..!!!