| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Variable within a formula
"Pete_UK" wrote...
Try this: =SUM(INDIRECT("WO!J2:J"&ROWS(WO!qry_WO)-1)) .... Or eliminate the volatile INDIRECT call by using =SUM(WO!J2:INDEX(WO!$J:$J,ROWS(WO!qry_WO)-1)) which has the added benefit that if rows were added above row 2 or columns inserted or deleted to the left of col J in the WO worksheet, the nonvolatile formula wouldn't need to be revised. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable substitution in a formula | Excel Discussion (Misc queries) | |||
| Using a variable in a formula | Excel Discussion (Misc queries) | |||
| Using a variable in a VBA formula | Excel Discussion (Misc queries) | |||
| why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
| Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
![Harlan Grove[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
