Hi guys,

I've looked over the net to find a function with varying success though nothing that can get around the merging of cells.

All I need is a function that can count all individual cells within a certain range that are of a certain colour (Fill colour, shown in a key, so a specified cell).

The trouble I've encountered is when merging cells, I might have X cells merged, all one colour but I can't get the count to be X.

This might have something to do with when I unmerge them, only one of them remains colour filled but I don't want to have to colour every cell individually and them merge them.

Please if anyone can help it would be very much appreciated.

Thanks