I'm trying to sum attributes based on if their ID matches the ID of other attributes in the feature class. To explain further, each road has it's own Replacement Cost and Section Number as well as a Super Section ID associated to it. A road can be a part of a Super Section with multiple other roads which will all share the same Super Section ID. What I want to do produce the total replacement cost of every Super Section for each road.
As you can see in the image above, the field Super_Section_Replacement_Cost has the replacement cost for the entire Supersection (the sum of the individual road replacement costs that are apart of the SS).
I was thinking an UpdateCursor might be useful but I'm not sure how I can group the attributes based on a specific field (the Super Section ID).