The answer question
" How to select the top “values” in each row of the spreadsheet [closed]" explained how to identify to top n items in a row.
I want to SUM the top 15 values in a row containing up to 30 values
I can do this in two ways (both long winded)
[values held in $B2:$AR2]
- create 15 new columns and populate them with
“=LARGE($B2:$AR2,n)” where n = 1-15 and then sum the 15 columns - create a single total column with a formula of 15 expressions
=(LARGE($B2:$AR2,1)+LARGE($B2:$AR2,2)+LARGE($B2:$AR2,3)+ …LARGE($B2:$AR2,15))
this gets very unwieldy for the top 50 !
is there a better way of doing this in Calc
In Excel I can use the formula
=SUM(LARGE($B2:$AR2,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15}))
in calc this just returns the highest value.
(Editing: I (‘Lupp’) only added the link to the post referred to at the beginning of this question.)