Multipe Ifs

Hi
In Column A i have employee names, Column B Their department, Coloumn C their designation , Column D their machines and Column E if he is present or not.
If i need to write a condition to count with conditions of person present in Department, designation wise and building wise , how is it possible?
Mentioned examples in the attached sheet.