Using named range in LINEST formula

[MahTah]

Hello All,
I want to use a named range in the LINEST formula (European version of Excel). It works fine if I just use a dynamic range in the formula like this:

=INDEX(LINEST((INDIRECT(ADDRESS($AQ$1;22;4)):INDIRECT(ADDRESS(COUNTA(B:B);22;4))); (INDIRECT(ADDRESS($AQ$1;27;4)):INDIRECT(ADDRESS(COUNTA(B:B);27;4)))^{1\2});1)

but of course, this is not easy to read and maintain along other formulas. Therefore I defined two named ranges of the above dynamic ranges as below:

DeltaTRange:

=INDIRECT(ADDRESS('Test Data'!$AQ$1;27;4)):INDIRECT(ADDRESS(COUNTA('Test Data'!B:B);27;4))

FlowErrorRange:

=INDIRECT(ADDRESS('Test Data'!$AQ$1;22;4)):INDIRECT(ADDRESS(COUNTA('Test Data'!A:A);22;4))

These are working correctly on a simple function like AVERAGE but using it in LINEST funcion as below gives a "#REF!" error.

=INDEX(LINEST(FlowErrorRange; DeltaTRange^{1\2});1)

How should I edit the formula above to make it working?

Thanks in advance
Mahdi

 

[Tetra201]

Try the following (cannot comment on the European syntax):

=INDIRECT(ADDRESS('Test Data'!$AQ$1;27;4)):INDIRECT(ADDRESS(COUNTA('Test Data'!$B:$B);27;4))
=INDIRECT(ADDRESS('Test Data'!$AQ$1;22;4)):INDIRECT(ADDRESS(COUNTA('Test Data'!$A:$A);22;4))

 

[MahTah]

Thanks Tetra201, that was what I was missing...

 

[Tetra201]

Glad to be of a help.