Having trouble figuring out why this would work for LINEST, but not for INTERCEPT, RSQ or STEYX, given they all have the same parameters and format. Additionally, I've tried all of those formulas in the exact same cell as the LINEST one that is working.
For background, the objective is to run multiple regressions against live data (being pushed externally to excel via an Excel Add-In API) on one sheet to act as a monitor.
The columns for both X's & Y's are dependent on numbers (for start column and end column) entered into cells E19 & E20 by the user.
EDIT: The rows for X's and Y's are dictated by formulas which match a value in column S to values in A23:A48 (for X's) and the row of the cell in question for Y's.
Formula below:
EDIT: The address combos in the first INDIRECT() are "V24:EX24" and for the second INDIRECT() are "V23:EX23"
Any help much appreciated!
Bookmarks