SumProduct & Index Match

Hi all,

I have a spreadsheet which predicts bus journey time savings from different packages of interventions at 2 separate and unrelated highway junctions.
In a sheet called i;BenefitsByType, I have a list of interventions, the journey time benefit (seconds) they each generate, a flag for whether they form part of a package (named 1.1 , 1.2, 2.1.1 , 2.1.2) and the junction movement codes affected by that intervention.
In a sheet called JTS_Matrices, I have a matrix for each package with the possible movements at each of the 2 junctions.

I want to automate populating the JTS_Matrices based on the time savings that a given package generates.

I have completed 2 of the 4 example JTS_Matrices manually to reflect the answers I'm expecting.

I added the 1's in the i;BenefitsByType sheet as a means of flagging which package(s), if any, a given intervention is part of, and as a means of doing a SUMPRODUCT of some kind.

In the JTS_Matrices, I'm envisaging some sort of SUMPRODUCT(i;BenefitsByType!$C$3:$C$16,i;BenefitsByType!$B$3:$B$16) but which only includes those where the matrix row ID &"_"& matrix row ID exists in i;BenefitsByType!$G3:$G$16, and which changes the i;BenefitsByType!$C$3:$C$16 part of the SUMPRODUCT depending on the Package matrix ... that way it's all dynamic by matrix cell and by package matrix

Any help or a solution would be excellent.

John you're a wizard, thank you very much, that's perfect.