Hi

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


Arvi Laanemets


"Pester" wrote in message
...
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.