Sum based on horizontal and vertical match

I need a help in the attached excel file

I need a lookup formula that can search the brand with the salesman name, to get the quantity sold.

Then it sum all the sold quantities, and put it in another table

Example: Brand A sold by salesman (Asif), then the excel should take 45 + 60, and add them in the other table