Hi Everyone,
I need a little help with a project I am working on.

I am in the process of making a schedule for work through Excel for all our
employees. I work at a hospital and we have all different shifts. We do the
schedule for 2 weeks at a time. What I did was make all the shifts people
work into a dropdown selectable list. Now the part I need help with is, I'd
like the spreadsheet to be able to count the number of personnel assigned for
each shift.

For example is I have 3 people selected as working 7a-3:30p, 2 people
7a-11:30p and 5 people 3p to 11:30pm, I want to be able at the bottom of the
spreadsheet, to automatically say that there are 5 people on day shift
(7a-3:30p) and then 7 people covering evening shift (3p-11:30). If someone
can tell me how I have to go about this or is able to help it me out, it
would be greatly apprecaited. If needed, I can send you my spreadsheet.

Thanks for all your help!