Counting Function (Non-blank, lookup, multiple categories)

Hello,

First off, I have had great luck here! So I'm glad I've found a resource I can depend on for help. Here is my issue:

I am working on an employee scheduling work sheet. I have employees who work in the field and employees who work in an office. When they take vacation time I need excel to record the total number of people within the office who are on vacation that day. I need to exclude the field workers from that list. I've included an example of what I'm doing.

The yellow highlighted cells are manually input right now. I want them to be automatic using the information and format given. I'm open to suggestions.

Thanks in advance - Jordan.