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.