Not SUM(), but MODE() will tell you what car number appears most often

"John James" wrote:


Put your 28 classes at the top of each column and put your votes for
each person on each row below the class headings. A sum function at
the bottom (or at the top) gives you the result

You can use window freeze to hold your titles in view.


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=534011