Match Multiple Values & Return Sum of Multiple Columns?

Hello,

I have a workbook with 2 worksheets, Last_Operation & Item_Matrix.
Last_Operation has a pivot table (columns Job, Item, Qty) with multiple item # (column A) & each's last operation # (column B) per job. See attachment for sample.
Item_Matrix contains multiple item # in column B (duplicated in 3 row groups) with operation # on the 3rd row in columns F:Y for each item. See attachment for sample.
What I am seeking is the sum of the Item_Matrix worksheet's Run Durations for the remaining operation # per each job on the Last_Operation pivot table.

For example:
Item # 1401400-001
Last_Operation = # 10
Item_Matrix shows remaining operations are 20, 25, 30, 40, 50, 60.
Sum of Run Durations for these operations is 1.18 (0.58 (Operation 30) + 0.5 (Operation 40) + 0.1 (Operation 50)).
^This sum of Run Durations for each job is what I'm struggling to generate.

Please help me.
Thank you.

EDIT:
Upon some attempts, I'm thinking referring to the pivot table may not work. Correct me if I'm wrong.
Please find attachment of the source data on worksheet JobOperations. Column BI is a helper column to filter the jobs by a WC #.

EDIT:
Attached a sample workbook.
Worksheet Last_Operation has a column with cell fill yellow that shows what the expected results to be. The job's perhaps the best example.

There are instructions at the top of the page explaining how to attach your sample workbook. Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

Ali,

Thank you.
I've edited the OP to include a sample workbook & some additional information.

Thanks. So you are expecting all 0 apart from the last result - is this correct?

Still not sure i understand but i had the below in cell J2 of the Last Operation sheet:

Formula:

Please Login or Register  to view this content.

Then i had this in cell L2 of the same sheet dragged down:

Formula:

Please Login or Register  to view this content.