Populate table from database with 2 conditions

Hello guys,

Hope you will be able to give me a hand. I have a pretty vast database which I populated through VBA from a certain number of worksheets. I now need to create a table which shows min, max and average for each location given x, y or z condition. So far I only approached it by creating a secondary table with each range address and then using INDIRECT, but this would require extra work on the database (insert a function to sort out locations alphabetically and within each Range.Location sort out by conditions (note. A, B and C are not in alphabetic order)) and is also very ugly.
I was wondering whether you had any more elegant ideas?
I attached a sample example of my spreadsheet hoping it will help!

Thank to whoever will spare the time to help me.

Best,
Carlo