Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals

[Matthewbat]

I have header names which includes Deal date, Raw Material Name (Example Iron), Source location of raw material (Example US),Volume (Example 20), Price (Example 150).

Can some one please help me how to do VWAP for all relevant raw materials please?

[VBE313]

So in this example the Iron VWAP would be (20 x 150) / 20 which = 150. If this is correct, what Raw Materials are relevant for your list?

[SamT]

Sum of Volume x Price divided by Sum of Volume