Make Ratings Equal Weight Across Factors

[ExcelerateMyLearning]

Hi there,

I'm working on an spreadsheet that compares different cities according to population growth, crime index, etc. It then provides a rating for each city relative to that factor compared to the other cities on the list. The ratings for the different factors are then added together to get an overview of which city performs the best across all factors.

My question: How do I make the ratings for each factor equal in weight?

I've attached my spreadsheet and highlighted the column headers I'm asking about.

Thanks for taking a look and any suggestions!

 

[AliGW]

We'd need to know the total out of which each factor is rated to weight them equally.