You need either to use XL4 macros which can crash Excel when copied in some
versions or VBA. There is not anything built in that will take a text string
that looks like a formula and then evaluate it.

Here's a link to a great add-in called Morefunc by Laurent Longre that has a
function called EVAL that will do this


http://xcell05.free.fr/



--
Regards,

Peo Sjoblom






"Sh0t2bts" wrote in message
oups.com...
Hi All,

I have a list of excel files what I produce a summary from the
calculations if the same for each cell that I want to enter only the
file name changes, I have writted the below function:-


=CONCATENATE("=SUM('[",'File list'!A1,E2,"]Monthly Charts'!$S$4:$W$5)/
5")

Which gets me the text that I want

=SUM('[Accounts Comms Sheet.xls]Monthly Charts'!$S$4:$W$5)/5

but is displays it as a text entry instead of been used as a function,
how can I get it to do the sum?

Cheers
Mark