Excel problem!! Urgent
2006-11-11 5:10 am
Would like to ask how to do a summary calculation of different worksheet in a workbook, e.g. I want to do a summary work sheet 1 to show all figure I have calculated in other work sheet 2,3,4,5,6 etc. How to do the link, I have tried to type = cell no, but it didn't work, can anybody help???
回答 (2)
2006-11-11 5:22 am
✔ 最佳答案
=SUM(Sheet1!A1+Sheet2!A1)e.g你在sheet7中的cell, 輸入加formular 的指令(=sum)，再去順序select 其他sheet 你要的cell，每次記得輸入cell 與cell之間的運算關係(+ - x / )，做完即可。
由於不是是否你要的做法，有誤會的話請補充說明。
2006-11-11 8:55 am
你係唔係唔記得打sheet name???
e.g. 如果你想在sheet 1 show 到sheet 2 cell A20 的內容, 你要係sheet 1 打入"+sheet2!A20"
e.g. 如果你想在sheet 1 show 到sheet 2 cell A20 的內容, 你要係sheet 1 打入"+sheet2!A20"
收錄日期: 2021-04-12 18:04:53
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061110000051KK03912