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

%3CLINGO-SUB%20id%3D%22lingo-sub-1520921%22%20slang%3D%22en-US%22%3EIn%20100%20rows%20there%20are%20values%20in%2010%20colums.%20How%20to%20create%20the%20sum%20of%205%20largest%20values%20for%20each%20row%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1520921%22%20slang%3D%22en-US%22%3E%3CP%3EI%20do%20not%20want%20to%20sort%20each%20row%20descending.%20Is%20there%20a%20fomula%20that%20selects%20and%20sums%205%20largest%20values%20pre%20row%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1520921%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1521057%22%20slang%3D%22en-US%22%3ERe%3A%20In%20100%20rows%20there%20are%20values%20in%2010%20colums.%20How%20to%20create%20the%20sum%20of%205%20largest%20values%20for%20each%20ro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1521057%22%20slang%3D%22en-US%22%3EChange%20the%20range%20reference%20to%20suit%2C%20but%20I%20believe%20this%20should%20work%20for%20you.%3CBR%20%2F%3E%3CBR%20%2F%3E%3DSUMPRODUCT(LARGE(A1%3AZ1%2C%7B1%2C2%2C3%2C4%2C5%7D))%3C%2FLINGO-BODY%3E
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.

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