I am working with the attached sheet and it is made up of groups of rows that alternate with a 6 digit NAICS code (industry code) then an aggregation of those codes into a more general 3 digit NAICS. I need to have the row with the 3 digit NAICS code calculate a number that multiplies a column called "% of industry" by several columns of of numbers and then sums the result into a cell in that 3 digit NAICS row. Different groupings have different numbers of rows. I would like to know if there is a 1 cell formula that can achieve this and be easily copied down the sheet to the other 3 digit NAICS rows.

You can see in row 37 this formula being executed for a simple 2 row aggregation. But that would take forever to replicate down the sheet, especially for the larger aggregations.
Maybe someone could do an example for row 32 that achieves the desired result and could be easily copied down the sheet.

3 digit Table Excel Help forum.xlsx

Thank you for your assistance with this.