求助，求一个商品原料日消耗表

苍域

=SUM(MMULT(($B$14:$D$14=$A24)*$B$15:$D$19*B$5:B$9,{1;1;1})) 数组公式

1786024734

1. =SUM(INDEX($B$15:$D$19,,MATCH($A24,$B$14:$D$14))*INDEX($B$5:$I$9,,MATCH(B$23,$B$4:$I$4)))

复制代码

mykitami

商品名称要统一起来，如：把A改为商品A，类推。
=LET(sj,DROP(REDUCE("",$A$5:$A$9,LAMBDA(x,y,VSTACK(x,HSTACK(TRANSPOSE($B$14:$D$14),DROP(REDUCE("",OFFSET(y,,1,,8),LAMBDA(n,m,HSTACK(n,m*TRANSPOSE(XLOOKUP(y,$A$15:$A$19,$B$15:$D$19))))),,1))))),1),SUM((TAKE(sj,,1)=$A24)*($B$4:$I$4=B$23)*DROP(sj,,1)))