Hi.
In the attached workbook I am manually adding 1 for Green, 2 for Yellow and 3 for Red in column C, then COUNTIF to get totals. I would rather Excel recognise and count all cells with same colour i.e. all Green, all Yellow and all Red. Can excel count by colour? If so How is it done? Thanks.
Bookmarks