text to formula

G

General

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.
 
B

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
 
G

General

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!
 
Top