I need some help please....

[Guest]

I am trying to set up some type of judging system.
I have 28 classes in a car show, each class has a letter and car number
(a1-a20, b1-b20 and so on). The people who entered their cars are the one who
vote for 1 car in each class and mark them all down on a voting sheet, then
they turn those sheets in and the votes are counted and added up.
I am trying to set something up so that all I have to do is enter the class
letter and car number (a1, x10, etc) and the program will then store all the
votes and then add them up for me, so I know which vehicles got the most
votes in which class..

To me it sounds like it would be some sort of inventory type system or
something, I am lost and need someones help ASAP in setting this up...

 

[Bob Phillips]

Why not just list the class in column A, the car number in column B, and
then every vote a class/car gets, put an X in the next free column of that
row (start at column D so that the count can go in C). Then use COUNTIF to
count them (=COUNTIF(D2:IV2,"X"))

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)