I have a spreadsheet where I need to put the different cities into regions.

I have a column of regions where I need them grouping (so to speak)

I then have another sheet with a comparison table on that currently compares each individual city. I want to compare a total of the regions instead?

Could someone please help/explain

Region Help.xlsm