總和名字後面數字 無數字為 1 (14693)

E1{=SUM(IFERROR(SUBSTITUTE(MID(SUBSTITUTE(SUBSTITUTE(A$1:A$7,"个",),"、",REPT(" ",19)),{1,2,3,4}*19-18,19),D1,)*1,))+COUNT(0/FIND(D1&"、",A$1:A$7&"、"))

(數字最大設定 702)E2=SUM(ISNUMBER(FIND(D1&COLUMN(A:ZZ)&"个",A$1:A$99))*COLUMN(A:ZZ))+COUNT(0/FIND(D1&"、",A$1:A$99&"、"))