Stacked bar chart average

Hi, need some help ;)

I have in column A the total price for a product (product type is in column C).

In column B I see how many of the product I sold.

So for example:

• 10€ / 5pcs / Apple
• 20€ / 3pcs / Banana
• 25€ / 6pcs / Peer
• 20€ / 11pcs / Apple 
• ... (of course thousands of products and thousands of lines)

So all the lines are a collection of all the sold items.

Now I wish to know what my price per pcs per product is in a pareto (what is the best item to sell).

I want to have the average off all the lines. Note for example that in the first line an apple cost 2€ and in the last line slightly less. So the prices are not always identical.

How can I do this? :)

I created a stacked bar chart to try and create a pareto, but it gives me the result of the SUM of all the apples. In this case 2€ + 1.8€ = 3.8€ in the pareto. But I want to divide this number by the amount of times there are apples in my column C. 

I hope my request is clear. It looks very logical in my head :D

Thanks in advance!