加總 每行取最小3數 加 1 (10030)

A5:H7{=A1+OR(A1=SMALL(IF($A1:$H1<>0,$A1:$H1,2^8),ROW($1:$3)))

A8:H8=SUMPRODUCT(A5:A7*$J1:$J3)

A9:H9{=INDEX(MMULT(TRANSPOSE($J1:$J3),IF(8-COUNTIF(OFFSET($A1:$H1,{0;1;2},),">"&IF($A1:$H3=0,99,$A1:$H3))<=3+MMULT(N($A1:$H3=0),ROW(1:8)^0),1,)+$A1:$H3),COLUMN(A1))