SUMPRODUCT formula issues

Please see attached.

I am having some issues around the SUMPRODUCT formula


1) Top 10 Sheet - Looking to populate Column C with the sum of the QTY(Source: Error Report Data Column K) column for each of the Defects listed in Column A.

2) 1st, 2nd and 3rd Top defect sheets, Having issues calculating the TOP 10 Components (F7:F16) from the Component list (Column A). The Top 10 values in Column G are correct, just the name is not corresponding correctly.

3) As well on the 1st, 2nd and 3rd Sheets, similar to the first issue, calculating the QTY (Source: Error Report Data Column K) but instead by defect it will be by Component listed in Column A

Hope this makes sense and I greatly appreciate anyone's time in advance for helping me out!

sample.xlsx