Hi
I have a worksheet which has values given to players in a league. in th elast cell of the range I have a formula which takes the 7th largest values, adds them together and gives a total of them.
=SUM(LARGE(B6:J6,ROW(INDIRECT("1:" & MIN(7,COUNT(B6:J6))))))
my problem comes when a player has not registered a score. If a player doesn't have a score, the formula returns a #REF! error because of course there is no numbers in the column. I cannot just enter zeros in the players score.
I am guessing that I need to put something similar to an IF statement or similar..... i.e. if the range doesn't have any number don't pick the largest numbers, but I cannot figure out how to do it.
I would appreciate any help.
Thanks in advance
G
Bookmarks