| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SUM 3D Reference using variable sheet limits
I want to SUM the values in the X35 cells from multiple sheets named for
months (Nov2008 . . May2009 etc.). I need to be able to easily change the limits of the sheets to be included in the calculation, (ie: Nov2008 . . May 2009, then recalculate for Jan2009 . . April2009). AD31 will contain the name of the first included sheet ('Nov2008), AF31 will contain the name of the last included sheet ('May2009). =SUM(INDIRECT(AD31:AF31&"!X35")) returns an incorrect number. I think it is missing the fact that the cell references refer to sheets, not cells. What formula or modification do I need? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How To make a sheet reference Variable (eq: sum(sheet!D2:H2)) | Excel Discussion (Misc queries) | |||
| VLOOKUPS: Limits on # per sheet? | Excel Discussion (Misc queries) | |||
| variable in a link where the variable is the name of the sheet | Excel Worksheet Functions | |||
| How to use variable in reference | Excel Worksheet Functions | |||
| Cell reference - for the sheet name, can I use a variable? | Excel Discussion (Misc queries) | |||
Threaded Mode
