統計個數 有連續符號 (13216)

E2:G5=IFERROR(ROWS(INDIRECT(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE($C2,"-",":"),"E",),"&",REPT(" ",99)),COLUMN(A1)*99-98,99)))),)

D2:D4=SUM(E2:G2)-SUMPRODUCT(N(MID(C2,ROW($1:$99),1)="-"))+SUMPRODUCT(N(MID(C2,ROW($1:$99),1)="&"))+1