If INDIRECT does not support 3D references, that explains why I could not get
my earlier idea to work. Sorry excelhurtsme.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Bernard Liengme" wrote:

If you just wanted the value in L20 from the sheet named in N20 you would
use
=INDIRECT(N2&"!L20")

So you might think you could use =SUM(INDIRECT("Sheet1:"&N20&"!L20")) but
INDIRECT does not support 3D references.

Do the sheet names form a nice series like Sheet1, Sheet2, ....Sheet10? If
so there is a nice trick shown in
http://groups.google.com/group/micro...816df8027ba006


By the way: The phase I think you wanted was "Value RETURNED by formula in
N20"

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"excelhurtsme" wrote in message
...
Is this possible? =sum(worksheet1:(RESULT OF N20)!L20)
with N20 having the formula to display the worksheet name in it?
not sure how to put in the (RESULT OF N20) into the formula if it is even
possible.