text to formula

[Guest]

I had to construct the following using concatenate (and cell info):
=sum($A$5;$C$8)

Now that I have the text version of the formula, I need to have excel
calculate that formula. Here is where I am stuck. I tried multiplying by 1
to no avail.

Ideas please.

 

[Bernie Deitrick]

General,

It would be far better to describe the entire problem.

But, you can do something like:

=SUM(INDIRECT("$A$5:$C$8"))

where the

$A$5:$C$8

part is made up by functions.

HTH,
Bernie
MS Excel MVP

 

[Guest]

you need to change the semicolon to a colon try
=sum($A$5:$C$8)

 

[Guest]

Thank you. I did not see my typo!

you need to change the semicolon to a colon try
=sum($A$5:$C$8)

 

[Guest]

Thanks for "indirect".
I ended up doing: =SUM(indirect($A$5):indirect($C$8))
Thanks for your 2 cents! I never would have gotten there with out it!