EXCEL中一单元格内 C70,C148-C155 这里面“-”代表连续性，怎么用公式分开并提出里面有几个数？

=ROWS(INDIRECT(SUBSTITUTE(TRIM(MID(SUBSTITUTE($A$1,",",REPT(" ",99)),99*(COLUMN(A1)-1)+1,99)),"-",":")))+ROWS(INDIRECT(SUBSTITUTE(TRIM(MID(SUBSTITUTE($A$1,",",REP