Hi
I am taking over a spreadsheet in Excel 2007 and I need to update it but I am stuck on one point. It is a spread sheet for 30 individual golfers who play say 34 competions, in each competion the winner is awarded 10 points, second 9 points and so on with the 10th placed 1 point the remainder 0 points. The names are on each row and the results in each column. What I need is a formula that will add up the points of the best 20 competions for each golfer and ignore the remaining 14 competion results. Help please.
Rod