Hi

=SUM(INDIRECT("'" & A1 & "'!A1:A10"))
where A1 contains sheet name


Arvi Laanemets


"Pester" <Pester@discussions.microsoft.com> wrote in message
news:E229E172-3DC3-4838-AC40-279B21332534@microsoft.com...
> I understand how to use the INDIRECT Formula but I am getting a #REF error
if
> the sheet I refer to has a space in between. If My reference is to look
for
> information from Sheet1 it works, but if it is from Sheet 1 it does not.
Any
> tips on this? This is critical because all the sheets refer to products
and
> have spaces in between the name.
>
> thank you.