I
Ivor Davies
I am trying to refer to a named range within an array formula without a great
deal of success - my original formula is as follows:
{=SUM(IF(Data!$A$2:$A$145=$B$6,IF(Data!$B$2:$B$145=$B7,Data!$C$2:$C$145,0),0))}
I want to change the reference "Data!$$B$2:$B$145" to the dynamicly named
range "Capital_Classification_1" so that if any extra lines of data are added
to the Data worksheet the array formula automatically picks this new data up
without me having to re-set the range in the array.
Is this possible?
deal of success - my original formula is as follows:
{=SUM(IF(Data!$A$2:$A$145=$B$6,IF(Data!$B$2:$B$145=$B7,Data!$C$2:$C$145,0),0))}
I want to change the reference "Data!$$B$2:$B$145" to the dynamicly named
range "Capital_Classification_1" so that if any extra lines of data are added
to the Data worksheet the array formula automatically picks this new data up
without me having to re-set the range in the array.
Is this possible?