I would use a DSum formula in column M for the Assy rows.You may need to put an extra column with total weight (C*M)