| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Indirect Function Doesn't like non-contiguous ranges
I was trying to use the indirect command to sum a named
range of cells. If I enter the following in a cell then the formula works if the text in the cell refers to a contiguous range. If I change the range to be non- contiguous, it gives a #ref error in the cell. Cell contents =+SUM(INDIRECT(I66)) I66 has the string "rng1" which is a named range on the current worksheet. Does anyone have any idea of any work around? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| indirect worksheet function in excel | Excel Worksheet Functions | |||
| INDIRECT function error | Excel Discussion (Misc queries) | |||
| INDIRECT function question | Excel Worksheet Functions | |||
| Indirect( ) function loosing values when spreadsheets are closed | Excel Worksheet Functions | |||
| Offset, indirect, match function limitation on linked worksheets. | Excel Worksheet Functions | |||
Threaded Mode
