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


You need to use an array instead


Google sheets SUM LARGE multiple nth largest elements

Functions used:

| improve this answer | |
  • 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. – marikamitsos May 20 at 17:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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