總和 依起訖格數 (12909)

D3:E3=IF($D$2=D$2,N($E2)+1,LOOKUP(1,0/(SUBTOTAL(9,OFFSET($B$3,,,ROW($1:$19)))-SUM($F$2:$F2)<=100),ROW($1:$19)))

F3=SUM(OFFSET(B$2,D3,,E3-D3+1))

D3:F3 下拉