例如: 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.