二文本後面數字取出 計算總和 (15156)

B2{=(COUNT(0/ISNUMBER(-MID(A2,ROW(1:98),1))/ISERR(-MID(A2,ROW(2:99),1)))-1)*MID(A2,FIND("各",A2)+1,99)

B8:B9{=SUM(MMULT(N(IFERROR(FIND(TRIM(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(LEFT(A$7,FIND("各",A$7)-1),"，","."),".","/"),"/",REPT(" ",99)),ROW($1:$9)*99-98,99))," "&MID(SUBSTITUTE(A8,"个",REPT(" ",99)),{1,2,3}*99-98,99))-1,)>0),RIGHT(SMALL(IFERROR(RIGHT(TRIM(MID(SUBSTITUTE(A8,"个",REPT(" ",99)),{1;2;3}*99-98,99)),{1,2})*1,)+{1;2;3}/1%,{1;2;3}*2),2)*1))*MID(A$7,FIND("各",A$7)+1,9)