括號裡 計算起訖號總數 (13545)

C2=-LOOKUP(1,-MID(B2,FIND("-",B2)+1,ROW($1:$9)))--LOOKUP(1,-MID(B2,FIND("-",B2)-ROW($1:$9),ROW($1:$9)))+1

另解=ROWS(INDIRECT(SUBSTITUTE(MID(B2,FIND("(",B2)+1,FIND(")",B2)-FIND("(",B2)-1),"-",":")))