weighted average profit margin

[mar123]

Hi. I'm looking for help with how to calculate weighted average profit margin. Basically, in an Excel spreadsheet, column A contains Sales numbers and column B contains Profit Margin % for each of those sales numbers. I need the weighted average profit margin for all sales combined.

Sales profit
$100 25%
$500 15%
$300 10%

 

[Denis]

[100(25) + 500(15) + 300(10)] / (100 + 500 + 300)

 

[mar123]

Makes sense.
Thanks!

 

[Denis]

Makes sense.

Makes cents !