Project Election Winner

  • Thread starter Thread starter Monk
  • Start date Start date
M

Monk

Hi,

This could be easy or difficult. We are having an election with
choices. Suppose I sum columns A, B & C, use the result to project
winner. 362 people will vote in total.
What would my formula look like?

Mik
 
Hi
not really sure what you will have in those column A, B, C

But you may have a look at MAX or RANK for this
 
Hi Mike,

in column D

=IF(SUM(A1:C1)=MAX($A$1:$A$100+$B$1:$B$100+$C$1:$C$100),"Winner","")

which is an array formula, so commit with Ctl-Shift-Enter, and copy down

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
It depends on what the data looks like. What numbers are in A,B,C? 1s and
0s?

If you are summing votes, why would you need to project?
 
Choices Option 1 Option 2 Option 3
362 Total Ballots 15 15 36
% of Total 4.1436% 4.1436% 9.9448%
Percent of Vote by Choice
22.7273% 22.7273% 54.5455%
Number of Votes 66
Percent of Voters Responding 18.2320%
Percent of Voters Remaining 81.7680%

Projected Winner ??????

Column e,f & g sum up the posted votes.
They happen to appear in row 365

So obviously some sort of logical formula using IF and MAX

Thanks so much
Mon
 
Thanks to all who responded. I suppose some sort of 'leaning' criteri
would be necessary to project a winner. This is a simple ballot with
choices and I went off on a tangent like it was some sort o
presidential election. It would be interesting to see what a formul
would look like that pictures the USA with each state divided int
percentage leaning, population etc.; start throwing in votes and le
the formula compute the winner.

Mik
 
Back
Top