I'm having an issue with the following formula:
INTERCEPT(OFFSET($AM$6,0,0,1,MonthOffset-COLUMN($AM$6)+3),OFFSET($AM$1,0,0,1,MonthOffset-COLUMN($AM$1)+3))
MonthOffset is just an integer, 72 in this case.
The above formula works fine with LINEST, rather than INTERCEPT. The issue is with the...