yep, I thought of that too
but the OP never mentioned it
or I missed that


On 19 Mar, 13:50, Dave Peterson wrote:
I don't think so.

=indirect() will return an error if the sending workbook is not open. *And based
on the drive and path, I'd bet that this file isn't open.





Jarek Kujawa wrote:

would this:

=STDEV(INDIRECT('O:\Shared\BrianB\AlphaTesting\
[PriceToSales_Download.xls]BANKS - Q'!$BK$5:$BK$"&J7))

help?

On 19 Mar, 13:08, Bongard wrote:
I am trying to adjust a range that is being referenced in a formula.
Here is my formula =STDEV('O:\Shared\BrianB\AlphaTesting\
[PriceToSales_Download.xls]BANKS - Q'!$BK$5:$BK$269) The number that
I'd like to be able to adjust is that 269. I have another cell that is
calculating the length of that range (essentially a dynamic range in
another workbook). The rest of the formula would remain the same but
I'd like it to work something like this =STDEV('O:\Shared\BrianB
\AlphaTesting\[PriceToSales_Download.xls]BANKS - Q'!$BK$5:$BK$&J7&)
where cell J7 is calculating a number for the end of the range. Can
this be done?

Thanks a lot,
Brian

--

Dave Peterson- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -