Sumproduct solution I think

[Centre13]

Hi Guys - would be very grateful for some help if possible. I think this is a sumproduct solution but am struggling to write the formula.

I have attached a file with the issue.

Effectively I have 4 products being sold by three sales teams. Each product pays a different commission amount.

I am tring to write a formula that calculates the total commission earned by each sales team.

I know I could do it via a two step process ( applying percentages to products in one column and then summing by team), but was hoping to achieve the same result in one step.

Any help would be much appreciated.

Thx

Tom