Using Translation Table to roll up information

[Jod84]

I have a sheet which pulls directly from a database so I don't want to add anything to that sheet if possible its basically an inventory record sheet showing stock and location. However location is at a very low level and I want my summary at a higher level so I have another sheet which lists how locations should roll up e.g.

Database Summary
Location Location

Zone A1 Zone A
Zone A2 Zone A
Zone A3 Zone A
Zone B1 Zone B
Zone B2 Zone B

So I want I want to do a sumif on database table to see how much stock by product is at each summary location I tried using an array as thought this would be the best way but failed miserably hopefully someone can assist me. Below is a sample of info in database

Product Quantity Location
A 2 Zone A1
B 3 Zone A1
A 5 Zone A3

So my summary table should look like below
Product Location Quantity
A Zone A 7
B Zone A 3

Thanks for your help