Chip,
Your formula is only looking at one sheet. OP wants to sum across multiple
sheets.
I'm thinking
=SUM(INDIRECT("Sheet1:"&N20 & "!L20"))
should work, but I can not quite get it to. Hopefully someone else can
elaborate, or figure out what I'm missing.
--
Best Regards,

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


"Chip Pearson" wrote:

I'm assuming that Sheet1!N20 contains the name of a worksheet from
which you want to get the value in L20. You can use the INDIRECT
function to do this:

=SUM(INDIRECT(Sheet1!N20&"!L20"))

Here, INDIRECT takes the sheet name from Sheet1!N20, appends "L20" to
it, and returns the SUM. So, if Sheet1!N20 contains the string
"Sheet3" (sans quotes), the formula is the same as

=SUM(Sheet3!L20)

You can use INDIRECT to convert any arbitrary text string into an
actual range reference that can be used with other functions.


Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Thu, 11 Dec 2008 12:26:01 -0800, exchequers
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.