有一个单元格表示单元格范围 [英] Have one cell represent a cell range

问题描述

Excel 2003问题：

我想要一个单元格表示一系列单元格。所以另一个公式可以使用它。

Excel 2003 Question:
I'd like to have one cell represent a range of cells. So that another formula can use it.

现在，我有一个方程来计算一个特定项目的工作时间。它寻找一个项目名称，然后在它旁边，我有一个列，我花了多长时间。这是公式 = SUMIF（D1：D10，project1，C1：C10）

Right now, I have an equation to sum the hours worked on a specific project. It looks for a project name, and then beside it, I have a column with how long i've spent on it. This is the formula =SUMIF(D1:D10,"project1",C1:C10)

如果你看在第一张图片上，

我想要B10表示持续时间（B23-B28）的范围

我想要C10表示Project（C23-C28）的范围

If you look at the first picture,
I want B10 to say the range of Duration (B23-B28)
I want C10 to say the range of Project (C23-C28)

现在看第二张照片，配有公式。

而不是手动使用范围，我只是想看看B10，而C10，所以我得到一度的范围这样，我只需要改变一个地方的范围，而不是改变我有多少项目。

Now look at the second picture, with the formula.
Instead of having the range manually, I just want it to look at B10, and C10 so I get the range once. This way, I only have to change the range in one spot instead of how ever many projects I have.

如果这是一个凌乱的问题，我很抱歉。我不知道如何问问，但如果人们对我要完成的任务不清楚，我将很快回答意见。

I'm sorry if this is a messy problem. I'm not sure how to ask it, but I will be quickly answering comments if people aren't clear on what I'm trying to accomplish.

推荐答案

使其更加清晰。您可以在单元格中输入范围（地址）作为文本，然后使用 INDIRECT 将它们引用到范围而不是文本。

Making it a bit more clear. You can enter the range (Address) as a text in the cells, and then use INDIRECT to reference them to a range instead of just text.

所以在单元格B10中输入

So enter

"C23:C46" in cell B10 (without quotes)
"D23:D46" in C10      (without quotes)

并使用 INDIRECT 在您的公式中 SUMIF

这是一张更清晰的图片。

and use INDIRECT in your formula for SUMIF
Here's a picture for more clarity.

这篇关于有一个单元格表示单元格范围的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！