Hello. I have a spreadsheet which I use to keep track of payroll. Days/cells are different colors depending on whether the employee worked, was sick, requested time off, location was closed, etc. I'm looking for a way to summarize both the number of cells that are a certain color and sum the total hours in a certain color. How do I do this? Thanks!