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

Many thanks to all who read my request, I have now solved it using an array formula.
Best wishes - Rod