Countif when cells filtered

AWESOME THANKYOU SO MUCH
Now one more question and I should be done, if I have an employee who will be demobbing from the project. I would put a D in the box (refer too employee 71) but I need to not count that one on my total numbers onsite, cause obviously they have gone