| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
INDIRECT for range of sheets
I want to sum cell D4 across a range of sheets.
I've got the first and last sheet names: Hello my name is Gilbert (in cell C1) I like squirrels (in cell C2 I've therefore put together: =SUM(INDIRECT("'"&C1&":"&C2&"'!D4")) The problem is the INDIRECT returns #REF! - I think because it's not a single sheet reference. What am I doing wrong? How else can I do this? Cheers, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| INDIRECT and multiple sheets | Excel Worksheet Functions | |||
| indirect function within sumif to reference other sheets | Excel Worksheet Functions | |||
| Indirect and Address in Reference to other sheets | Excel Worksheet Functions | |||
| Sum Indirect function through multiple sheets | Excel Discussion (Misc queries) | |||
Threaded Mode
