EXCEL AUTOSUM
回答 (3)
2006-11-17 10:52 pm
✔ 最佳答案
應該係你個 excel set 左做手動計算, 改返佢做自動就 OK.平時如果個 file 入面有好多 formula, 都會 set 做手動計算, 只有按 F9 才會 calculate, 可以省卻 loading 的時間, 當然 save 時佢都會自己 cal 一次
工具 > 選項 > 計算 > 自動 > OK
2006-11-17 8:42 pm
you have set the wrong formula
the one you have set is item E20 times item F20
if you want to add up a list of numbers like from E20 to E24,
then the formula should be "=SUM(E20:E24)"
if you only want to add the two numbers in E20 and F20
then I suggest you to use the formula like this " =E20+F20 "
the one you have set is item E20 times item F20
if you want to add up a list of numbers like from E20 to E24,
then the formula should be "=SUM(E20:E24)"
if you only want to add the two numbers in E20 and F20
then I suggest you to use the formula like this " =E20+F20 "
2006-11-17 8:10 pm
加總的程式 : SUM(E20:F20)
SUM 即是加
: 即是由 E20 加到 F20
* 即是乘
SUM 即是加
: 即是由 E20 加到 F20
* 即是乘
收錄日期: 2021-04-12 22:35:05
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20061117000051KK01100