excel sum of top10 in range

[hargi]

Hi fokes,

Need a formula to calculate the sum of the 10 ten numbers in a range its for a league table, best 10 scores out of 20 weeks count.

=SUM(LARGE(C2:w2,{1,2,3,4,5,6,7,8,9,10})) This works when there is 10 or more numbers in the range c2:w2 but if there is less then i get a #num1 error

Is there a way to get this to work for the first 9 weeks?

TIA

 

[mattx2]

Try

=IF(ISERROR(SUM(LARGE(C2:W2,{1,2,3,4,5,6,7,8,9,10}))),SUM(C2:K2),SUM(LARGE(C2:W2,{1,2,3,4,5,6,7,8,9,10})))

 

[hargi]

Cheers Mattx2 that seams to work