I occasionally create fictional elections for fun and experiment with different methods of doing them. This time, I did an election for the presidency of a country, and I planned to carry it out with a Condorcet method. For those who aren’t familiar, a Condorcet method is any election system that declares the candidate who can beat all of their competitors, or more of the other candidates than anyone else, the winner. This winner is the Condorcet winner. I created a way to calculate who would be the Condorcet winner with a bunch of tables within my spreadsheet.

I have some problem with the code.. I’m stuck with summing ‘COUNTA of PROBLEM INFO’ by ‘CODE’. I want to have for example: 0 –> (score) 11, 97 –> (score) 6.
SS