cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

ggksenior
Copper Contributor

‎Jul 14 2020 06:07 AM

‎Jul 14 2020 06:07 AM

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?

Labels:
467 Views
0 Likes
1 Reply
Reply
1 Reply
JMB17

‎Jul 14 2020 07:18 AM

‎Jul 14 2020 07:18 AM

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

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

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