You are here:

Question
We have a competition that has 7 contestants.

Each contestant votes for 1st-6th place for the other 6 contestants.

The totals determine who gets 1st-7th places.

Every vote for 1st place gets 100 points.
Every vote for 2nd place gets 70 points.
Every vote for 3rd place gets 45 points.
Every vote for 4th place gets 25 points.
Every vote for 5th place gets 10 points.
Every vote for 6th place gets 0 points.

The contestants vote by receiving a piece of paper similar to this:

1. __________
2. __________
3. __________
4. __________
5. __________
6. __________

They simply enter the names of the other 6 contestants based on how they'd place each.

I would like for the person tallying votes to input the information from all 7 pages into a file and let that file do all the math for them.

How do I do that?

Thanks!

It is probably easiest to use a worksheet which has a row for each person and then enter the person's place on the appropriate row. That way you avoid typo problems in the names.

You can then get the person's 1 scores with a formula like this (assuming you have scores all the way to column AA and start entering scores in column B. For row 2:

=COUNTIF(B2:AA2,1)*100

2's are scored as follows:

=COUNTIF(B2:AA2,2)*70

Etcetera.
Questioner's Rating
 Rating(1-10) Knowledgeability = 10 Clarity of Response = 6 Politeness = 10 Comment No Comment

This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here

#### Jan Karel Pieterse

##### Expertise

Excel and Excel/VBA questions

##### Experience

Excel MVP

Organizations
Self employed Excel developer

Education/Credentials
Bachelor in Chemical Engineering

Awards and Honors
Microsoft MVP award since 2002

Past/Present Clients
Shell, Fortis bank, ABN-AMRO bank, Morgan Stanley, ...