I am trying to workout a worksheet for a British Open Game. The Rules are you pick 6 players, but you only take the best 4. I was able to work out the 1st player because his picks are all in order so it is =(SUM(SMALL(F2:F7,{1,2,3,4}))) but the second player has picks in cells f2:f4 and f8:f10. It comes up error when I try to select them. Please help. Thank you.
Bookmarks