COUNTIF, SUMIF, for a range of data

Hi all,
I need the formula in C5 (an then consecutive rows)- the criteria are in the attempted formula of cell C5
To do the same math as in cells G3:IA3
Goal: to use 1 worksheet per part by utilizing ONLY column C for this formula and eliminating any links

I know there is a way to combine formulae to get to where I need to go.
I have suceeded with the formula placed to calculate my colums (features) into %pass rates.
I need to do the same with each row (for each part).
Currently I have 2 workbooks to get the results I need for the rows in workbook1.
Workbook1 = data (linked to workbook2 to retrieve pass rates)
workbook2 = calculating pass rates of workbook

I have copied a sample of what workbook2 is reading from workbook1 starting in row 20 of the attachment.
I would like to keep everything in ONE workbook, and each part to ONE worksheet.
Workbook1 currently contains 40+ worksheets (one part per worksheet, 2 worksheets in the sample)
Each sheet starts with data from Jan 1st and will collect data until Dec 31st, which usually takes up anywhaere between 10 parts to 5000 parts (rows)

Thank you