| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible to offset a worksheet reference?
I have a workbook with n worksheets. I would like to sum the cells from
Sheet2 to Sheet(n-1). The names of sheets 1 and n are static, but names on other sheets change. Is there any way to do a 3D reference with an offset in the worksheet specifier, so that the formula works regardless of the number or names of the worksheets in the middle? Something like =SUM(('Sheet1'+1):('SheetN'-1)!O4) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| offset reference | Excel Worksheet Functions | |||
| Circular Reference / OFFSET | Excel Discussion (Misc queries) | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| How to reference an offset from a cell? | Excel Worksheet Functions | |||
| Can the offset worksheet function reference another worksheet | Excel Worksheet Functions | |||
Threaded Mode
