Invoice Formula

[carl]

My data table looks as so:

Volume Buyer Seller ChargedSide
2 BOX980 BOX226 Buy
30 BOX226 BOX917 Sell


I am trying to find a formula for this table below:

Charge Credit
BOX980 100 (2 x $50) 0 (0 x $25)
BOX917 180 0
BOX226 0 800 (2x25 + 30*25)

So for each ColA, look at the DataTable and depending on if the Buyer or
Seller is on the "ChargedSide" calculate the appropriate Charge or Credit.

Thank you in advance.