自动算出多少人数 (11844)

D3=MID(B3,FIND("-",B3)+1,9)-LEFT(B3,FIND("-",B3)-1)+1

另解{=COUNT(ROW(INDIRECT(SUBSTITUTE(B3,"-",":"))))

另解=-IMREAL(IMDIV(B3&"i","1+i"))*2+1

另解=ROWS(INDIRECT(SUBSTITUTE(B3,"-",":")))