In 100 rows there are values in 10 colums. How to create the sum of 5 largest values for each row?

Occasional Visitor

I do not want to sort each row descending. Is there a fomula that selects and sums 5 largest values pre row?

1 Reply
Change the range reference to suit, but I believe this should work for you.