取组合最小值 (9348)

D2{=IF(B2,B2,MIN(IF(ROW(A1)=ROW($1:1)-1+TRANSPOSE(ROW($1:1)-1),IFERROR(D$1:D1+TRANSPOSE(D$1:D1),""))))

C3 下拉=IF(B3,"",MIN(MMULT(N(OFFSET(B$1,ROW($1:1),{0,1}))+N(OFFSET(B3,-ROW($1:1),{0,1})),{1;1})))

另解C2=IF(B2,B2,MIN((N(OFFSET(C$1,ROW(1:$2)-1,))+N(OFFSET(C2,-ROW(1:$2)+1,)))))