寻找除一些列外的SUM [英] Finding SUM except some columns
本文介绍了寻找除一些列外的SUM的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
以下是我所拥有的。
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ A + B + C + D + E + F + G + H + I + J + K +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+ 1 + 2 + 3 + 4 + 5 + 6 + 7 + 8 + 9 + 10 + 50 +
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
要查找此行的 SUM ,不包括 Cell E
我使用如下公式。
To find the SUM of this row excluding Cell E
I am using formulae as below.
= SUM(A1:D1)+ SUM(F1:J1)
=SUM(A1:D1)+SUM(F1:J1)
注意:单元格K
SUM。
有任何替代方式吗?
以上只是一个例子,但在我的表中有大约100列,我需要排除大约10-15列。
Above is just an example however in my sheet there are around 100 columns and I need to exclude around 10-15 columns.
推荐答案
我相信
=SUM(A1:J1)-E1
更清楚地传达您的意图。 (当然,排除的列包含数字)
conveys your intention more clearly. (provided the excluded columns contain numbers, of course)
这篇关于寻找除一些列外的SUM的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文