Snappy helper

I schedule my weekly time slots by color. This gives a quick view of time blocked for each activity.
It does not enter results into cells within the spreadsheet, only shows them in a pop-up window. If that is all you need, this is perfect! (If you need the count to appear within your worksheet look for a VBA solution.)

TedinSC about Count & Sum by Color for Microsoft Excel