Tabulation Form

[RobertBC]

good day!
imdoing a tabulation form for an election.. my problem is how can i get the maximum vote using functions no vba code if necessary...

scenario...
on the illustration above the total no of voters per precinct is my max vote for each person.. what i wanted to do is on "Juan" he got 50 and 80.. the max vote now for hin is 180 if he get 50 votes on the 3rd prcinct..

[Bob Phillips]

And why wouldn't it just be 50,0,0?

[RobertBC]

And why wouldn't it just be 50,0,0?

my problem is like how the bowling scoreboard runs.. the max score is 300 for 10 frames and each frame has the max score of 30.. if you got 25 in first frame your max scor now will be 295 because the 5 is less from 30 on the first frame.

[Bob Phillips]

That clarified nothing for me. I have never heard anyone liken an election to a bowling game before. Again, I cannot see why Juan doesn't get all 50 left, leaving nothing for the rest.

[RobertBC]

thanks anyway.. i just use the bowling scoreboard because what am i looking for is how it works..