Forum Discussion

PamFinn's avatar
PamFinn
Copper Contributor
Feb 18, 2024
Sorry, but this doesn't work as the system is picking up A1:A7 as the range A1:A7. I copied and pasted your solution to ensure that I did not make any typos.
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Feb 18, 2024

PamFinn 

=SUM(LARGE(B1:B24,ROW(A1:A7)))

 

ROW(A1:A7) evaluates to {1,2,3,4,5,6,7} which means that range A1:A7 isn't picked up by the formula. You can actually enter any data in A1:A7 such as formulas, text or numbers and verify that the formula doesn't refer to the entries in this range.

 

  • PamFinn's avatar
    PamFinn
    Copper Contributor
    Feb 18, 2024
    I see where the problem is, Oliver - my query was not clear enough, so apologies 🥴. I have a spreadsheet (for a weekly golf competition) with a list of names in column A and columns B to AA for scores received. I need to calculate the total of the best 11 scores for each person in column AB. Thanks. Pam
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Feb 18, 2024

      PamFinn 

      In AB2:

      =SUM(LARGE(B2:AA2,ROW($A$1:$A$11)))

      or

      =SUM(TAKE(SORT(B2:AA2),,-11))

      Fill down.

      • PamFinn's avatar
        PamFinn
        Copper Contributor
        Feb 18, 2024
        Thank you, I will try that

Resources