Formula that returns formula won't show result...

  • Thread starter Thread starter bimmerman
  • Start date Start date
B

bimmerman

I have a formula which creates a formula. I want to display the results
of the created formula but instead the cell is just showing the
formula.

I have no idea how to correct this and any help would be great!


Formula that creates the other:
=REPLACE(REPLACE(REPLACE(G1,5,1,D1),8,1,D1),1,0,"=")

Created Formula:
=SUM(A7:A21)

So the cell where all of this is happening is actually showing
'=SUM(A7:A21)' with the equal sign and all but it's not showing the
result!!
 
Hi Bimmerman,

Actually what you have created is simply a text string and
not a formula. You'll notice that the returned string is
enclosed in single quotes. There is no way to piece
together components from separate cells to build a formula
like you are trying to do. The closest thing to being able
to do that is using the INDIRECT function to build the
references used in a formula.

Biff
 
It looks as if you have:
G1: SUM(x7:x21)
D1: A

If you want to sum cells in rows 7 to 21 of whichever column is specified in
D1, use the formula:
=SUM(INDIRECT(D1&7&":"&D1&21))
 
Sorry about the confusion, there are no single quotes around my result
I just put them in my question to clearly show exactly what was bein
returned.


And Stephen Bye, that looks like it will work because what yo
described is exactly what I need to do and that formula looks like i
can work. I will give it a shot on Monday when i get back to work.

Thanks
 
Back
Top