Find the value in the table and add up the instances of a team's total sales-From a table

[sniper1]

Experts,

I ran into some issues with doing this project from a table perspective. I have a table (Table2) that has the info I need to populate in sheet2. I need to find Team A or B in the table and then show values in sheet2 under the sales category, sale range(100-399), 400-699), (700-1000), (>1000). The sales categories are in D2 and I2 of sheet2.

Thank you all!!!!!!