If Countif Output Count Rank SUMPRODUCT

Situation ››› We have some Employees/ Names in the column 'B', and the respective cell in the column 'A' shows abt the status of their work on the same task.

Aim ››› Now we would like to count their 'Completed' work status with the numbers so tht we can give them rank on their efficiency. If we come to know abt the exact 'Pending' work status, so we can easily know where we r running behind, and this count can help us to put penalty on those employees if they miss the target.
If the required result automatically comes up in a table then it'd be easier to paste data in the monthly master workbook and get the final monthly summary.

P.S. - It'd be better if anyone tell me how rank employees on their 'Completed' work status.

Note - Plz check the attached MS workbook for the details.

Thanks in Advance!