そういう関数は無いですが、数式を組めばやれはします。
=LET(num,$C$2,data,SORT(TRIMRANGE($A$2:$A$1000)),target,$B$2,leng,ROWS(data),seqa,SEQUENCE(POWER(leng,num),,0),set,INDEX(data,MOD(INT(seqa/POWER(leng,SEQUENCE(,num,num-1,-1))),leng)+1),bool,((INDEX(set,SEQUENCE(ROWS(set)),SEQUENCE(,num-1))\u0026lt;INDEX(set,SEQUENCE(ROWS(set)),SEQUENCE(,num-1)+1))),fif,BYROW(bool,LAMBDA(x,AND(x))),fil,FILTER(set,fif),sums,BYROW(fil,LAMBDA(x,SUM(x))),FILTER(fil,sums=target,\u0026quot;\u0026quot;))
