计算列和组的数值 (11025)

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)