求一个算工时的公式

dongfangxielong

         在黄色区域C11:C17写函数公式，结果如图所示， D列为说明结果是怎么算来的

良良

C11=SUM(VLOOKUP(T(IF({1},TEXTSPLIT(A11,","))),IF({1,0},A$3:A$8,B$3:B$8*CHOOSE(ROW($1:$6),1,1,B11,B11,1,1)),2,))，三键。

无关岁月

1. =SUM(COUNTIF(A11,"*"&A$3:A$8&"*")*B$3:B$8*IF(B$3:B$8<1%,B11,1))

复制代码

part98

=LET(s,TEXTSPLIT(A11,,","),SUM(XLOOKUP(s,$A$3:$A$8,$B$3:$B$8)*IF(BYROW(s,LAMBDA(x,OR(x=取样))),B11,1)))

博爱风雨同舟

=LET(a,MMULT(--($A$3:$A$8=TRANSPOSE(TRIM(MID(SUBSTITUTE(A11,",",REPT(" ",99)),ROW($1:$4)*100-99,99)))),ROW($1:$4)^0)*$B$3:$B$8,SUM(IF(a<=0.004,a*B11,a)))

127000

1. =SUMPRODUCT(VLOOKUP(TEXTSPLIT(A11,,","),$A$2:$B$7,2),IFERROR(--TEXTSPLIT(SUBSTITUTE(SUBSTITUTE(A11,$A$5,B11),$A$6,B11),,","),1))

复制代码

沈默00

=LET(t,SUBSTITUTES(TEXTSPLIT($A11,,","),$A$3:$A$8,$B$3:$B$8)*1,SUM(IF(t>=0.5,t,t*$B11)))

wlc5201130

=SUM(ISNUMBER(FIND(A$3:A$8,A11))*B$3:B$8*IF(INT(ROW(B$2:B$7)/2)=2,B11,1))