单元格标识号 [英] Cell identifier number
问题描述
我需要在Excel范围内使用SUM函数,例如 = SUM(A12:A25)
。
I need to use a SUM function over an Excel range, for example, =SUM(A12:A25)
.
有没有办法在另外两个单元格中存储数字 12
和 25
,并在SUM功能?
Is there a way to store the numbers 12
and 25
in another two cells and use them in the SUM function?
推荐答案
而不是 INDIRECT
,您应该使用 INDEX
因为它不是挥发性的。如果B1显示第一行,B2表示最后一行,那么您的公式将为:
Instead of INDIRECT
, you should use INDEX
because it is not volatile. If B1 shows the first row and B2 the last one then your formula would be:
=SUM(INDEX(A:A,B1):INDEX(A:A,B2))
如果B1为5,B2为7,那么它将总和B5:B7(和所说,以不易变的方式)。在超过90%的情况 INDEX()
和 INDEX():INDEX()
将是一个更好的解决方案 OFFSET
和/或 INDIRECT
。 ;)
If B1 is 5 and B2 is 7, then it will sum B5:B7 (and as said, in a not volatile way). In over 90% of the cases INDEX()
and INDEX():INDEX()
will be a better solution than OFFSET
and/or INDIRECT
. ;)
这篇关于单元格标识号的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!