| Home |
| Search |
| Today's Posts |
|
#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. |
| 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 | |||
Threaded Mode
