如何能將顯示的儲存格加總

2007-02-15 7:02 pm
如何能將顯示的儲存格加總,而隱藏的儲存格則不用加?
例如: A1 – A10 分別是 1,2 3,4,5 6,7,8,9,10, Cells A4-A6 是隱藏的儲存格,
如何計算出答案是40 ?
更新1:

to: Cristalland, If I have a great number of cells, and I do not want to count the hidden cells, how to set the formula? Your steering please.

回答 (1)

2007-02-15 7:10 pm
✔ 最佳答案
需要將計算程式修改成:-

=SUM(A1:A3,A7:A10)
參考: my experience


收錄日期: 2021-05-02 19:26:30
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070215000051KK01023

檢視 Wayback Machine 備份