How to search on one column and then count distinct entries in another column (Excel)

I am trying to compare sales data from two tables. The first table shows product info (Location, product code etc.), and the second table shows all transaction data (Location, product code, customer ...