Need Help with Excel Count Function

Hi Guys,

Great forum, and this is my first post here.

See attached the excel sheet I have created. What I want to do is count the number of shifts per day and have a drop down menu reflect the result of shift in each department.

Eg - Total Tally
AM 4
PM 4

The drop down would contain FRONT OFfice and the tally should change accordingly.
So far I have only managed to get a tally of the entire sheet however the drop down menu needs to be activated.

Please help

Warm regards and thank you,

Vishal Gulati.