计算时间范围内的某货品用量总和

喂你吃粑粑

1. =REDUCE(0,计划!$A$3:$A$10,LAMBDA(Y,X,Y+SUMPRODUCT((X=$A$3:$A$123)*(Q3=$B$3:$B$123)*$C$3:$C$123*SUM(OFFSET(计划!$B$3,MATCH(X,计划!$A$3:$A$10,0)-1,MATCH($P$3,计划!$B$2:$K$2,0)-1,1,MATCH($P$5,计划!$B$2:$K$2,0)-MATCH($P$3,计划!$B$2:$K$2,0)+1)))))

复制代码

wj65134

1. =REDUCE(0,A$3:A$123,LAMBDA(x,y,SUM(x,IF(OFFSET(y,,1)=Q3,OFFSET(y,,2)*SUM(OFFSET(计划!A$2,MATCH(y,计划!A$3:A$10,),MATCH(P$3,计划!B$2:K$2,),,P$5-P$3+1))))))

复制代码