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