Total only the 7 largest scores in range of 10

[bobbby1949]

I need to make a score sheet that only totals the top seven out of ten scores per person. The lowest score will drop after seven are entered.

Seems simple, but I am struggling to write the correct code. Appreciate any suggestions.

[NBVC]

Try:

=SUM(LARGE(A1:A10,{1,2,3,4,5,6,7}))

adjust range to suit.

[bobbby1949]

NBVC, Thanks for the quick reply. Your code works, as long as there are at least 7 scores in the range. But, I still have a dilemma.

To be more precise, the scores are registered every week. So, if I want the sum of the scores to show from week one forward, your code doesn't return a number until I have 7 scores entered. Can the code be adjusted to recognize all the scores, and also when we get past 7, return only the 7 highest?

I hope I am explaining this correctly.

[NBVC]

Try:

=SUMPRODUCT(SMALL(A1:A10,ROW(INDIRECT("1:"&MIN(7,COUNT(A1:A10))))))

[daddylonglegs]

You could also try this version

=SUM(IF(COUNT(A1:A10)>7,LARGE(A1:A10,{1,2,3,4,5,6,7}),A1:A10))

[bobbby1949]

NBVC, That worked well. It did exactly what I wanted to.

daddylonglegs, I'll try your code too. It is shorter than NBVC's. But since I already have it working, it will be later.

I can't tell you how much I appreciate the help I receive here.

Thank you both.