How do I calculate totals for each bin from the top list into the bottom list? I guess It needs to sort through the bin cells and select the value in the Qty Cell and then the Value call. Part number is not needed

Bin Part QTY Value
Lon 1p1 1 $20,200.00
Bei 2p2 2 $30,000.00
Vie 3p3 1 $40,000.00
BHS 4p4 3 $10,000.00
Nrk 5p5 2 $20,000.00
Nrk 1p1 2 $10,000.00
Lon 3p3 1 $20,000.00
BHS 2p2 3 $2,000.00
Bei 5p5 4 $1,000.00
Vie 4p4 2 $3,000.00


Bin QTY Value
Lon 2 $40,200.00
Bei 6 $31,000.00
Vie 3 $43,000.00
BHS 6 $12,000.00
Nrk 4 $30,000.00