text to formula
 

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.

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

"General" wrote in message
...
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.

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

"General" wrote:

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.

Thank you. I did not see my typo!

"bj" wrote:

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

"General" wrote:

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.

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!

"Bernie Deitrick" wrote:

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

"General" wrote in message
...
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.