Hi all,
Think I may have bitten off more than I can chew in creating a SCRABBLE spreadsheet for my local running group. We are looking to do an event each week (create a new tab each week) and that's all good. But I want to create a leaderboard that tracks how many times someone has played and what there overall score is from the weeks they have played in.
The Leaderboard tab is where I'm having issues. I will try as best to make my issues clear.
Names - self explanatory
Played - how many weeks they have participated. Can't figure out how to count check to see if Alex played in Week1, Week2 etc and tihs could run for 20 weeks!
Points - so I've entered a vlookup to return the points for Week1 but there are errors (I've put these next to them) and now I don't know how to add Week2 scores to it
Really sorry, probably as clear as mud but hopefully someone could help?
Bookmarks