=AVERAGE(INDIRECT("[InductionEcon_data.xlsm]InductionEcon_raw!$BF$"&$B5):OFFSET(INDIRECT("[InductionEcon_data.xlsm]InductionEcon_raw!$BF$"&$B5);36;0))
The baove function works well if the source file "InductionEcon_data.xlsm" is open, but does not work if it is closed.
After reading several forums I tried even with INDIRECT.EXT function, but still that didn't helped me...
I could get =(INDIRECT.EXT("[InductionEcon_data.xlsm]InductionEcon_raw!$BF$"&$B5) working by writing full path of the source file!! but still it couldn't help me to average the 36 value as shown in above formula..
Can anyone help me to get the above function working??
Does anyone know how to get the values from worksheets which are not open, especially in complecated calculations like above...
regards
rkanchan
Bookmarks