# How to SUM LARGE 5 largest elements out of 8 numbers in a row

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

``````=SUM(LARGE(C5:L5,{1,2,3,4,5}))
``````

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”. You need to use an array instead

``````=ArrayFormula(SUM(LARGE(C7:L7,{1,2,3,4,5})))
`````` 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
• 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