Assign a text to a Cell function

[Juan R]

Hello,

After some formulations and functions, I have a
concatenate() function in a cell that shows as result as
following:
=SUM(DDAS!M2DAS!T2)
The thing is that I need this to become a formula and to
show me the result, but because it is comming from a
concatenate function, I just see it as text in its cell.
Does anybody knows how to extract this formula and
execute it in another cell?

Thanks.

 

[Dave R.]

You don't need DDAS! repeated in there like that,
=SUM(DDAS!M2:T2) would suffice.

If you have this text (that looks like formula) as a result of pulling and
concatenation, why can't you just use the same pulling techniques to put the
info into a formula?

 

[Juan R]

I have tried, but the SUM function doesnt work, actually,
everything results from this:

I have to Sum values from one cell to other...those cells
depend on a Reference and a start week (The original DB
are a lot of references with their demand on each week).
So the input would be the reference and the first week,
and depending on the reference I have to SUM 4 or 5 or 6
weeks from the start week. So what I do is:
1. With MATCH functions I find the Columnn and Row
numbers for the first week of the correspondent
reference, then, by adding 4,5 or six to the column
number, I now the row and column numbers for the last
week in the range that I must SUM.
2. With the ADDRESS function, I find the address of those
two cells (That is why i have two DDAS in the SUM
function, because the DB is in a worksheet called DDAS.
These ADDRESS functions results in DDAS!M2 and DDAS!T2 as
text in two cells.
3. Then I concatenate those two results with the SUM()
function, and get this in a cell: =SUM(DDAS!M2DAS!T2)
But it is just text, I need it to execute.

 

[Bruce N.]

Sounds like you have the cell formatted as text. If you change it to general, it should work

 

[Dave R.]

Try the INDIRECT function. You can put text strings within it to reference
cells.

 

[TKT-Tang]

Please study the CHOOSE worksheet function in the Help File. You may
find it adaptable to your purpose.
Regards.