計算数字数量 (9530)

 

  D2=TEXT(SUMPRODUCT(N(MID(TRIM(SUBSTITUTE(B2&" A","/"," ")),ROW($1:$99),1)=" ")),"0;;")

另解=TEXT(LEN(TRIM(SUBSTITUTE(B2&" A","/"," ")))-LEN(SUBSTITUTE(TRIM(SUBSTITUTE(B2&" A","/"," "))," ",)),"0;;")

另解=TEXT(SUMPRODUCT((MID("/"&B2,ROW($1:$99),1)="/")*ISNUMBER(-MID(B2,ROW($1:$99),1))),"0;;")