Forum Discussion

Copper Contributor

Jul 14, 2020

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

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

Bronze Contributor

Jul 14, 2020

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

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