Sheeloo,

OP is trying to sum across multiple sheets, not just the one value.
--
Best Regards,

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


"Sheeloo" wrote:

Try
=SUM(INDIRECT("'" & N20 & "'!L20"))

basically construct a string which gives you the address and pass that to
INDIRECT...
Since you have only one cell L20 then why are you using SUM? If you just
need the value in L20 then use
INDIRECT("'" & N20 & "'!L20")

Also if worksheet name does not have spaces then you can use
=INDIRECT(N20 & "!L20")

"excelhurtsme" wrote:

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.