Weighted Averages

I currently have an Excel file (see attached) with the following

one sheet containing every single transaction of items i.e.
one sheet with a Pivot Table



A - B - C
PART01 - 1 - 5.78
PART01 - 1 - 5.78
PART01 - 1 - 5.78
PART01 - 1 - 5.78
PART01 - 1 - 5.78
PART01 - 1 - 7.58
PART01 - 1 - 7.58


Doing an average of Column C weights it accordingly and gives me a value of 6.29. This is great because it's taking into account the many orders of 5.78 each.


...and what I'm looking to achieve is by using a Pivot Table I can see a list of all the items sold, how many were sold and the average price which is weighted accordingly.
So using the sample data in the Excel file it would look like this

avg.PNG

Appreciate any help

Hi JeteMc, thank you for taking the time to reply and yes indeed your method worked brilliantly. It just so happened I did figure it out myself with the Formula you mentioned (hence my late reply), but your method builds it into the Pivot Table, which will prove really useful going forward