Sumproduct solution I think

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

Thank you very much. Works a treat. Have a great day!!!

I am having problems wih the formula unfortunetaly. Appears that the look up vector needs to be in ascending order. This is very diffciult in my spreadsheet.

Is there a way around this.

thx