Excel 2007 : Weighted Average Not Working in Pivot Table

I see this over and over and I tried to follow the procedure, but for some reason it is not working. Please see attached.

Your manual formula is incorrect. It should be =C4/SUM(A2:A3). Logically, you spent $1555.65 on 85 total units, so the average price is simply total spent divided by total quantity. The pivot table result is right.

Thank you. Live/Learn!