报表跨表页取数函数REF-F函数重算表页数据错误
深蓝
1,175次浏览
编辑于2017年03月13日 17:00:52
报表跨表页取数函数REF-F函数重算表页 有的单元格能算出数有的算不出来，而且同一个单元格有重算后有时有数有时就是VALUE 值错误的提示，检查了公式设置没问题。而且重算一个表页半个多小时了都算不完，终止重算以后也是VALUE值错误的提示。
下面是其中一个单元格的公式："=REF_F(""ZLYWZL01|3|KJHSTX01_SYS|203|||"",""江苏中联理货业务种类收入表"","""","""","""","""",""B6"")+REF_F(""ZLYWZL01|3|KJHSTX01_SYS|203|||"",""大连中联理货业务种类收入表"","""","""","""","""",""B6"")+REF_F(""ZLYWZL01|3|KJHSTX01_SYS|203|||"",""浙江中联消防业务种类收入表"","""","""","""","""",""B6"")+REF_F(""ZLYWZL01|3|KJHSTX01_SYS|203|||"",""北京中联理货业务种类收入表"","""","""","""","""",""B6"")"
推荐阅读