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.

I appreciate the reply.
I'm trying to avoid array entry, since I'm helping someone else with this. The reason I'm avoiding it is twofold: first, I want them to be able to modify and understand the entry, and second, my understanding is that arrays have a higher chance to corrupt the file over time.

Well, I had come across it searching for information on complex functions before. If I recall it was trying to make very specific formulae for conditional formatting. What I had previously read was that large arrays (since many of the sheets I use contain hundreds or even thousands of lines of data in excel) can corrupt or make a worksheet unstable. However, when I searched it just now I was unable to find any evidence of that. This leads me to believe I either misread, or it's an uncommon problem.

Regardless, I may end up instituting the array function if I can't find another way.

Wow thanks guys! I am in the middle of trying the two suggestions above. I have one issue: In my example I should have noted "Away" could instead be any one of 24 possibilities, so I was going to try and have it count non-blank cells. Is there a way to amend the above countifs statement to instead of counting "away", counting non-blank cells like the counta function?

Edit: I just thought of this, I can just add 24 versions of the statement together. However, I am hoping there is a simpler way. Despite the fact that copy pasting is simple, more so I'm looking for more basic formula code.

Also - as a follow up question:

If the order of the names do change, is Tony Valko's/an array solution better? I am trying to think of the same individual sheet, month to month. The name list will in fact be at the end of the year, so it's a multiple sheet workbook as opposed to all in the same sheet. Names can be added or taken away month by month, only the name list will be cumulative.