排序 累加後數值 (9146)


E2{=SUM(RIGHT(IF(ROW($2:$9)/1%+B$2:B$9<=RIGHT(SMALL(B$2:B$9/1%+ROW($2:$9),ROW(A1)),2)/1%+SMALL(B$2:B$9,ROW(A1)),ROW($2:$9)/1%+B$2:B$9,),2)*1)


F2{=RIGHT(SMALL(B$2:B$9/1%%+SUBTOTAL(9,OFFSET(B$2,,,ROW($1:$8))),ROW(A1)),4)*1


留言