employee schedule

I am making an employee schedule for seven days and each days for AM and PM shift using a drop down option for names (attachment) , what i am looking for is to how to count the names for all 7 days to ensure no one works more than 6 days and have the names and number of the shifts they work on C 23 (names) and c24 ( how many shifts they work).
I thank you all in advance