How can I set formular for auto sum for below in excel:
I want auto sum to be calculated based on "the sum from B4 to B20" minus "sum from C4 to C20".
I doesn't work the formular like this: =SUM(B4:B20)-(C4:C20)
Please help. Thanks
Excel Formular
2012-03-12 5:46 pm
回答 (1)
2012-03-12 10:23 pm
✔ 最佳答案
It doesn't work because you missed a (sum) symbol it should be =SUM(B4:B20)-SUM (C4:C20)
please try. Hope this can help!
收錄日期: 2021-04-23 14:33:16
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20120312000051KK00130