Help with order form auto sum with VLookup?

Hi,    I need help creating a formula which will add up how much each player owes based on their order as below.  Not sure if I have the right formula for a start?