Help with tallying votes

Copper Contributor

Hello, I am the secretary of a car club. We hold an annual car show. I would like to create an excel spreadsheet that would list cars 1 through 200. each car needs 3 categories attached to it. 

 

Then, either on the same sheet or a second sheet I'd like to be able to collect the paper ballet from the voter and enter, as an example, that the voter choose car number 10 for category 1, car number 80 for category 2, and car number 115 for category 3. Once I enter those values it would automatically tally on the first sheet. 

1 Reply

@JoshSterling 

See if you can use the attached workbook as starting point.