Combined count if and index match

To visualize my problem, please download attach file first. How to count completed status across rows and column all the related Company code and task code on other tab back to summary tab if the arrange of column is vice versa. Hope you could help me. Below list of requirements.


1. I have 2 tabs, Summary and Employee Name. Employee will input on Employee name tab completed task with date. And will be summarize back to Summary tab
2. As you notice Company code on this Summary tab is by arrange by rows on the other tab(Employee name tab) it is arrange by column,
3. As well the Task code on this tab arrange by column and vice versa on other tab
4. I want to count respective text per Company code & Task code using index count if all completed items across sheet. All counts must be convert to percentage.