In Excel I am able to get the output using this formula:


But in Google Sheets I am unable to get the right answer. Can anyone please help?

In the image below, observed 7th row the sum must be 49/50 using the technique =SUM(LARGE(C7:L7,{1,2,3,4,5})) but the solution is showing as “10” instead of “49”.

enter image description here

1 Answer 1


You need to use an array instead


Google sheets SUM LARGE multiple nth largest elements

Functions used:

  • Have you tried the given solution? Did it work for you? If not we should try finding out why. If yes, as per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. May 20, 2020 at 17:56
  • Is there an easy way of converting this to a range of rows? May 4, 2021 at 13:56
  • @RafaGuillermo I guess you wanted to use this for your answer here? It would involve cumulative sum but never tried it out. I tend to avoid overcomplicated formulas, unless really needed. May 13, 2021 at 21:02
  • 1
    yeah was just trying to expand on the premise. I try to avoid complicated formulae if I can too, I’m not as formula savvy as I could so oftentimes I find a custom function does the job just as well even if sometimes a bit slower. Will take a look at cumulative sim though, thank you for the response. May 13, 2021 at 21:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.