NA

JinZheFeng · 发表于 2019-4-12 12:52

SUMPRODUCT(([HBVINChuNaZhongZhang.xlsx]日记账!$A$4:$A$9999=C39)*([HBVINChuNaZhongZhang.xlsx]日记账!$B$4:$B$9999=$D$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$C$4:$C$9999=$E$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$F$4:$F$9999))/SUMPRODUCT(([HBVINChuNaZhongZhang.xlsx]日记账!$B$4:$B$9999=$D$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$C$4:$C$9999=$E$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$L$4:$L$9998))

X2030 · 发表于 2019-4-12 14:08

SUMPRODUCT(([HBVINChuNaZhongZhang.xlsx]日记账!$A$4:$A$9999=C39)*([HBVINChuNaZhongZhang.xlsx]日记账!$B$4:$B$9999=$D$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$C$4:$C$9999=$E$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$F$4:$F$9999))/SUMPRODUCT(([HBVINChuNaZhongZhang.xlsx]日记账!$B$4:$B$9999=$D$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$C$4:$C$9999=$E$37)*([HBVINChuNaZhongZhang.xlsx]日记账!$L$4:$L$9998))

问题1.引用区域不同
问题2.可能数据源工作簿关闭

JinZheFeng · 发表于 2019-4-12 14:20

X2030 发表于 2019-4-12 14:08
SUMPRODUCT(([HBVINChuNaZhongZhang.xlsx]日记账!$A$4:$A$9999=C39)*([HBVINChuNaZhongZhang.xlsx]日记账!$ ...

谢谢您真的非常感谢

		自动登录	找回密码
密码			免费注册

NA

最新热点 /1