Assign a text to a Cell function

  • Thread starter Thread starter Juan R
  • Start date Start date
J

Juan R

Hello,

After some formulations and functions, I have a
concatenate() function in a cell that shows as result as
following:
=SUM(DDAS!M2:DDAS!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.
 
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?
 
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!M2:DDAS!T2)
But it is just text, I need it to execute.
 
Sounds like you have the cell formatted as text. If you change it to general, it should work
 
Please study the CHOOSE worksheet function in the Help File. You may
find it adaptable to your purpose.
Regards.
 
Back
Top