Slope formula where data for y series resides in two workpapers

[ExcelFL]

I am trying to use the slope formula where my data for the y series resides in two workpapers. I don't want to combine the data into one workpaper to make the slope formula work. Instead I want to use a formula that appends the y series in one workpaper to the y series in the other.

Current formula in use I am using is:

=SLOPE(INDIRECT($C10&"2013!"&"b22:M22"),INDIRECT($C10&"2013!"&"b8:M8"))

This only references one workpaper which is the issue.

Any help greatly appreciated.

Thanks

 

[Domenic]

Let's say that C10 and D10 contain the values used for the name of both worksheets, try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER...

=SLOPE(N(OFFSET(INDIRECT("'"&T(OFFSET(C10:D10,,INT((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B22:M22"))*2))-1)/12),,1))&" 2013'!B22:M22"),,MOD((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B22:M22"))*2))-1),12),,1)),N(OFFSET(INDIRECT("'"&T(OFFSET(C10:D10,,INT((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B8:M8"))*2))-1)/12),,1))&" 2013'!B8:M8"),,MOD((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B8:M8"))*2))-1),12),,1)))

Hope this helps!

 

[ExcelFL]

Let's say that C10 and D10 contain the values used for the name of both worksheets, try the following formula that needs to be confirmed with CONTROL+SHIFT+ENTER...

=SLOPE(N(OFFSET(INDIRECT("'"&T(OFFSET(C10:D10,,INT((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B22:M22"))*2))-1)/12),,1))&" 2013'!B22:M22"),,MOD((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B22:M22"))*2))-1),12),,1)),N(OFFSET(INDIRECT("'"&T(OFFSET(C10:D10,,INT((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B8:M8"))*2))-1)/12),,1))&" 2013'!B8:M8"),,MOD((ROW(INDIRECT("1:"&COLUMNS(INDIRECT("B8:M8"))*2))-1),12),,1)))

Hope this helps!

Great; I am going to test this out!

 

[Domenic]

Also, if there are any empty cells, they're considered as zeros...