Use INDIRECT() to splice cell contents:


=SUM(INDIRECT("[" & B10 & "]Sheet5!$a$5:$a$10"))

--
Gary's Student


" wrote:

Can you tell me if this is possible?

Instead of putting the file name in the original cell, I want to
reference it.
For example, cell B10 contains "ABC.xls"

But in A1 I want to refer to it like this:
=SUM([B10]Sheet5!A5:A10)

Do I need to add quotation marks or anything? It doesn't seem to like
this...

Thanks