I'm trying to set up an AP Top 25 style poll via Google Sheets ( https://en.wikipedia.org/wiki/AP_Poll ). What I want to do is list the voters' choices on one sheet, and have them totaled and sorted on another. I'll set up a set of examples to describe what I'm trying to do.
Under this example voting scheme, a school gets 5 points for a 1st place vote, four for 2nd, three for 3rd place, two points for 4th place, and one point for 5th. Let's say I manually enter three sets of votes as such:
Under this setup, Alabama should have 11 points, Georgia 8 points, Clemson 10 points, Ohio State 9 points, and Washington 7 points. What I want to do is have another tab of the same sheet calculate the point totals of each school based on which cell they're placed in, display that point total, and sort itself from the greatest number of points to least number of points.
Now, I already understand some basic google sheets functions like sum, product, etc. What I'd like to do is have the "totals" tab populate automatically based on whats entered on the votes tab, without having to type out each individual school. So I need a way for the "totals" tab to look at the first entry in B2 on the votes tab, see "Alabama", make its own entry for "Alabama" on the totals tab, and then add the score for each subsequent entry for "Alabama" on the votes tab based on what column position its in in its respective row. Then do the same for any other unique school entry on the votes tab. Am I making sense?