Hi, I've got a spreadsheet where people select the colour they think is going to win. The 'Outcome' sheet goes the outcome of the challenges and which colour won which challenge. The 'Board' sheet shows how many points someone is on. The 'Event' sheet show which colours the players selected.
So in challenge A, C, D, James chose the correct colour. I'm trying to add two points to James' points tally for each win. So essentially James should now have six points as he won three times. I'm just unsure of the formula to use to calculate the total points for each user.
You may notice the challenges in the 'Event' sheet are spaced apart because there is other data which goes in between and I also need this to work in Excel 2010. Please see attached. Any help would be great. Thanks.
Bookmarks