Sum lines with duplicate values in Excel

Hello,

I understand there have been several posts related to the merging of rows but none specifically meet my needs.
So here is my problem:
i got datas on 3 columns, rows numbers are unknown (could be 0 or 180+).
Take the column C as a name (or Code), for each code i want to sum Not OK and sum of Tot. checked.
Once i got this i need to calculate for each code the formula " Sum Not OK" / " Sum of Tot.checked"
After that, i have to put that in a order top 10.


I added the file to the post.

Any assistance would be much appreaciated, please let me know of any questions.

Thank you.