如何将第二行数字自动填入表格中(第四行已标注想填入的行数及系数）？

sky83

如何将第二行数字自动填入表格中(第四行已标注想填入的行数及系数）？

清梦扰

=LET(a,TEXTSPLIT(C$4,"/"),b,XLOOKUP("第"&ROW()&"行*",a,a,"",2),IF(b="","",--TEXTAFTER(b,"*",,,,1)*C$2))

hugeinfo

=LET(b,TEXTSPLIT(C4,{"第","*","行"},"/"),BYROW((ROW(C5:C17)=--TRANSPOSE(CHOOSECOLS(b,2)))*TRANSPOSE(IFNA(CHOOSECOLS(b,4),1)*C2),LAMBDA(a,SUM(a))))

祝洪忠-

1. =IF(COUNTIF(C$4,TEXT(ROW(),"!*第0行!*")),INDEX(TEXTAFTER(TEXTSPLIT(C$4,,"/"),"*",,,,1),COUNT(C$4:C4)+1)*C$2,"")

复制代码

小凡、、、

=IFNA(VLOOKUP("第"&ROW()&"行",TEXTSPLIT(C$4,"*","/",,,1),2,0)*C$2,"")
举例数据48有误

袁勇

1. =TEXT(SUMPRODUCT(TEXT(0&SUBSTITUTE(SUBSTITUTE(TRIM(MID(SUBSTITUTE(C$4&REPT("/第n行",15),"/",REPT(" ",100)),ROW($1:$15)*100-99,100)),"第"&ROW()&"行",),"*",),"0;0;!1;!0")*C$2),"[>0]0;")

复制代码

低版本，非数组公式。