CONCATENATE always generates a string; never a formula.
I cannot work out what you need.
What is the purpose of 'File list'!A1,E2?
It would seem you need to use the INDIRECT function not CONCAT
Please spell out what task you need to perform without reference to CONCAT
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"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