Ranking question

Hi

I'm comparing 2 locations, and would like to show the ranking I gave to each category in a summary table.

In the attached spreadsheet, I have 2 tabs (for each city) where I rank each category 1-5
In the summary tab I have the comparison for each category and want to show the ranking for each city (e.g. city 1 got a rank of 4 and city 2 got a rank of 5 for the first category)

Thanks fir the help
S