seanhen1984
New Member
- Joined
- Jun 17, 2011
- Messages
- 4
I have created an input cell to automatically change which month to start summing an array at from a different data file, in order to calculate month-to-date numbers. However, unless I have the other excel file open, "#REF!" shows up if I enter anything after month 2. Here is the formula I am using:
=SUM(C:\exceldata\[2011 Data.xls]BRANDS (2011)'!$D11:INDEX(C:\exceldata\[2011 Data.xls]BRANDS (2011)'!$D11:$O11,INPUT!$D$3))
=SUM(C:\exceldata\[2011 Data.xls]BRANDS (2011)'!$D11:INDEX(C:\exceldata\[2011 Data.xls]BRANDS (2011)'!$D11:$O11,INPUT!$D$3))
