Forum Discussion
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?
1 Reply
- Change the range reference to suit, but I believe this should work for you.
=SUMPRODUCT(LARGE(A1:Z1,{1,2,3,4,5}))
