Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUM with INDIRECT.EXT
I am trying to sum up a range of cells in an unopen, external worksheet.
Using INDIRECT.EXT, I have only been able to do so if the row number of the beginning cell is less than 100. For example, =SUM(INDIRECT.EXT("'C:\[MyBook.xls]MySheet!b99:b704")) will work. However, =SUM(INDIRECT.EXT("'C:\[MyBook.xls]MySheet!b100:b704")) will work only for an open worksheet, not a closed one. Additionally, if the ending cell row is 1000 or more, regardless of the beginning cell, the formula will not work for a closed workbook. Does anyone know if this problem can be solved, so that I can use INDIRECT.EXT with SUM over the full range of a worksheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using SUM with INDIRECT.EXT
hmm wrote...
.... Additionally, if the ending cell row is 1000 or more, regardless of the beginning cell, the formula will not work for a closed workbook. .... I can't replicate this problem. IOW, SUM(INDIRECT.EXT(..)) returns expected results whatever the starting and ending rows are. Are you sure you're using the latest version of MOREFUNC.XLL? The current version is 4.2 released 5 March 2006. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use INDIRECT.EXT for this? | Excel Worksheet Functions | |||
INDIRECT.EXT reference | Excel Discussion (Misc queries) | |||
INDIRECT.EXT Help Required | Excel Worksheet Functions | |||
INDIRECT.EXT help needed | Excel Worksheet Functions | |||
Data from closed workbooks (pull func, indirect.ext, etc ....) | Excel Worksheet Functions |