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
Bookmarks