F6:H6{=SUM(MMULT(N((0&MID(F5,ROW($1:$99)*2-1,2))-TRANSPOSE(ROW(INDIRECT($B6&":"&$D6)))=0),ROW(INDIRECT("1:"&$D6-$B6+1))^0))
另解=SUMPRODUCT((MID(F5,(ROW(INDIRECT("1:"&CEILING(LEN(F5)/2,1)))-1)*2+1,2)*1>=$B6)*(MID(F5,(ROW(INDIRECT("1:"&CEILING(LEN(F5)/2,1)))-1)*2+1,2)*1<=$D6))
留言
張貼留言