This would be my guess using INDIRECT.

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

HTH,
Paul

--

"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