Forum Discussion
Re: Adding smallest 5 values
As variant you may select proper columns by index, modifying m_tarler formula
=SUM( AGGREGATE( 15,6, 1/(1/INDEX(Table1[@[A]:[G]],1,{1,3,4,6,7,8})), {1,2,3,4,5} ) )
1 Reply
the HSTACK() should work:
=SUM(AGGREGATE(15,2,1/(1/HSTACK([@a],[@c],[@e],[@f],[@h])),{1,2,3,4,5}))and in addition to Sergei's suggestion using INDEX you could use CHOOSECOLS()
=SUM(TAKE(SORT(IFERROR(1/(1/CHOOSECOLS(Table1[@[a]:[h]],1,3,5,6,8)),""),,,1),,5))if you are having problems please post the actual formula you tried so we can see what might be wrong or better yet a worksheet with non-private/non-personal information.
