Multiple lookup and their Sumup

[Swat84]

I want to sum up the value for multiple lookup in the table and get their sum up value. Where i have SKU linked with another SKU and i need to know total value available.

For instance - SKU 2 122233 is part of 112131 and also 142434 , however 142434 is part of 475767 also. I want a report to tell me how much stock i have currently of 122233 - 150 and not only 50.
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"]A[/TD]
[TD="width: 64"]B[/TD]
[TD="width: 64"]C[/TD]
[TD="width: 64"]D[/TD]
[TD="width: 64"]E[/TD]
[TD="width: 64"]F[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]SKU 1[/TD]
[TD]SKU 2[/TD]
[TD]Qty[/TD]
[TD]SKU[/TD]
[TD]Stock[/TD]
[TD]SKU[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]112131[/TD]
[TD="align: right"]122233[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]122233[/TD]
[TD="align: right"]50[/TD]
[TD="align: right"]112131[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]112131[/TD]
[TD="align: right"]132333[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]142434[/TD]
[TD="align: right"]25[/TD]
[TD="align: right"]142434[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD="align: right"]142434[/TD]
[TD="align: right"]778899[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]475767[/TD]
[TD="align: right"]75[/TD]
[TD="align: right"]475767[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD="align: right"]142434[/TD]
[TD="align: right"]122233[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD="align: right"]475767[/TD]
[TD="align: right"]142434[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD="align: right"]475767[/TD]
[TD="align: right"]374757[/TD]
[TD="align: right"]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 448"]
<colgroup><col width="64" span="7" style="width:48pt"></colgroup><tbody></tbody>[/TABLE]
So it should give me total of

In Column F 1 i did a formula ,=IFERROR(INDEX($B$3:$B$8,MATCH(0,INDEX(COUNTIF(G$2:$G2,$B$3:$B$8),,),0)),"")
and in G1 i did =SUMIF($B$3:$B$8,G3,$F$3:$F$5)

this is not working