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

Highlighted
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
Highlighted
Change the range reference to suit, but I believe this should work for you.

=SUMPRODUCT(LARGE(A1:Z1,{1,2,3,4,5}))