使用单元格中的值作为公式中的单元格引用? [英] Using the value in a cell as a cell reference in a formula?
问题描述
我想知道如何从另一个单元格的值中提取单元格引用,并将其插入公式。
I'd like to know how to pull cell references from the value of another cell and insert them into a formula.
有一个简单的例子:
在单元格A1中,我有: COUNT(B4:H4)
In cell A1 I have this: COUNT(B4:H4)
而不是在设置公式时选择范围,我希望这个范围是基于其他单元格中的值来动态的。
Instead of choosing the range when I set up the formula, I'd like this range to be dynamic, based on the value in other cells.
所以,我想输入单元格引用:在单元格B4
中,我将输入 C5
,并在 H4
我会输入 C8
。如何设置我的公式来查看单元格 B4
和 H4
,但是返回由这些单元格中的值( C5:C8
在这种情况下...)
所以最后,单元格A1将返回 C5:C8
So, I want to type in cell references: in cell B4
, I'd type in C5
, and in H4
I'd type in C8
. How can I set up my formula to look inside cells B4
and H4
, but then return the range that is defined by the values in these cells (C5:C8
in this case...)
So in the end, cell A1 would return the count of C5:C8
我希望这是有道理的。看起来似乎很简单,但我似乎找不到信息。感谢提前。
I hope that makes sense. It seems like something pretty simple but I can't seem to find info on it. Thanks in advance.
推荐答案
使用 INDIRECT()
=SUM(INDIRECT(<start cell here> & ":" & <end cell here>))
这篇关于使用单元格中的值作为公式中的单元格引用?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!