#REF! error in formula

[Tenerifebear]

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

[Aardigspook]

Surround your formula with an error check:

Please Login or Register  to view this content.

Replace the "no scores" with just "" if you'd prefer a blank instead.

[Tenerifebear]

Thanks Aardigspook, much appreciated.

[Aardigspook]

You're welcome, glad I could help and thanks for the rep.

If you're satisfied that your question has been answered, then please take a moment to mark the thread as Solved so others know there's an answer here (instructions are in my sig in my previous post). Thanks.