Sumif from list?

[ASingh91]

I am trying to create a spreadsheet to track the progress of a bet at the minute, basically the bet revolves around goalscorers in football (soccer) this would then be collated into a leaderboard based on one point per correct selection

I am trying to formulate it so that for each correct pick it will add one point to the end column. I would do this by choosing from a list of Yes/No Then this would increment the end column depending on Yes/No so +1 for Yes & +0 for no

How would I go about putting this as a formula

Then for the leaderboard it would pull the scores which would be on a separate sheet for each "matchday" then automatically update and sort highest to lowest

Thanks in advance

 

[cmerrick]

Set up your data validation for 'Yes' & 'No' then ese

 =COUNTIF(*cell*:*cell*,"Yes")

- this will give you your total

 

[ASingh91]

Thanks for this part

When I am doing the table for total points how can I set it to dynamically change based on the other sheets calculations I.e week 1 player 1 gets 4 points player 2 gets 2 points, week 2 player 1 gets 0 points player two gets 3 points

How can I automatically sort largest to smallest

 

[cmerrick]

Your best bet would be to record a simple macro of you sorting the table into largest to smallest and then assign it to a button so with one click you can refresh. That's what I would do anyway