I have a spreadsheet with 742 rows (of company names).
I have 5 columns of criteria for the companies.
Each column is a different criteria about each company, and has a numerical
rank for each company. 1-~75 (some columns/criteria have no rank for a
company)

I want to create an overall rank of the companies based on how they perform
across the 5 rows. I want the companies with the most 1's at the top and then
those with 1 & 2's and then those with 2 & 2's etc.

Is there a way to sort or rank this spreadsheet of companies?