求助，字段数值提取求和

gang64

请高手指教，单元格内数值提取后汇总，表格见附件

hcm19522

E4=SUMPRODUCT(LEFT(SUBSTITUTE(B4:D4,E$3,REPT(" ",9)),9)*1)

F4=SUMPRODUCT(SUBSTITUTE(MID(SUBSTITUTE(B4:D4,E$3,REPT(" ",9)),9,9),F$3,)*1)

一公式E4:F10=SUMPRODUCT(MID(SUBSTITUTE(SUBSTITUTE($B4:$D4,$E$3,REPT(" ",9)),$F$3,),COLUMN(A1)*9-8,9)*1)

ssg365

列：=SUM(--TEXTBEFORE(B4:D4,"列"))
组:=SUM(--SUBSTITUTE(TEXTAFTER(B4:D4,"列"),"组",))

gang64

感谢各位大神 完美解决难题