Trend formula not accepting Offset ranges

[DanRiverBrew]

Hi,

I'm not sure why, but if i manually type out the following formula, i receive an answer
=TREND($D$26:$V$26,$D$13:$V$13,$W$13)

but when i put in Offset formulas because the columns are ever growing
=TREND(OFFSET(D26,0,0,1,OffsetCount),OFFSET(D13,0,0,1,OffsetCount),OFFSET(D13,0,OffsetCount))

Where OffsetCount is a named range for a formula that works out to 19 right now. The resulting formula for the trend/offsets is the exact same as the manual formula, but the result i receive is #VALUE.

thoughts?

[DanRiverBrew]

nevermind, the formula is suddenly working

[arlu1201]

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

[DanRiverBrew]

ah yes, thanks. I meant to do that, but forgot due to editing to remove the attachment (my mind got sidetracked)