Counting cells with specific text (name) and cell colour??

[Clemo1]

Hi guys,

Need a VBA code to count holidays, days off etc. in a calendar year.
Basically I have a spreadsheet with all the months and dates of a year.
Each staff member has his/her name entered into the spreadsheet for say:
Blue cell colour for holiday.
Red Cell colour for day off...……………..
That cell will also have the name of the staff member who is on holiday or having a day off.
By the end of the year I need to know how many holidays, days off, late days etc. each staff member has had.

I can easily count/sum by colour or by text but having two (colour and text) to count/sum seems a lot more difficult.

Thanks.?

 

[Fluff]

Duplicate Holiday count

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).