This topic has been archived. It cannot be replied.
-
工作学习 / IT技术讨论 / Excel从外部引入.用光标选中几个Cell,屏幕右下角不显示sum=***,而且这几个cell的和是0.如B21=subtotal(9,B1:B20),B21总是0。在同样的Workbook,另一个sheet里，却会显示sum=***，cell的和是正确的.咋办？谢谢
-siva(50/50 winner);
2004-12-6
(#2016393@0)
-
i don't have excel on hand. select a cell ->right click -> gerneral/number. compare the cell between the two wokrshee.t
-647i(盲人协会);
2004-12-6
(#2016620@0)
-
select a cell ->right click ->property -> gerneral/number
-647i(盲人协会);
2004-12-7
(#2017085@0)
-
for total, i use sum(a1:c30)
-647i(盲人协会);
2004-12-6
(#2016622@0)