Updating Range Names

[ExcelUser777]

Hello,

I have a named range in the formula below..... BS_UM_0606....


=ROUND(SUMIF(BS_Um_Code,'Summary BS'!$A10,BS_Um_0606),0)


I have other named ranges for example 0607

My goal is to enter 0607 in a cell and have the 0606 update to 0607

Is there a way to update a range name by typing in a new range name in
a cell?




Thanks,
ExcelUser777

[Ardus Petus]

check INDIRECT

HTH
--
AP

"ExcelUser777" <lax_777@comcast.net> a écrit dans le message de
news:1143744195.242175.79450@u72g2000cwu.googlegroups.com...
> Hello,
>
> I have a named range in the formula below..... BS_UM_0606....
>
>
> =ROUND(SUMIF(BS_Um_Code,'Summary BS'!$A10,BS_Um_0606),0)
>
>
> I have other named ranges for example 0607
>
> My goal is to enter 0607 in a cell and have the 0606 update to 0607
>
> Is there a way to update a range name by typing in a new range name in
> a cell?
>
>
>
>
> Thanks,
> ExcelUser777
>

[ExcelUser777]

Ardus,

do you have anything more solid?

Thanks
ExcelUser777

[Bob Phillips]

Assuming that 0606 is in cell C1 for instance,

=ROUND(SUMIF(BS_Um_Code,'Summary BS'!$A10,INDIRECT("BS_Um_"&C1)),0)


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"ExcelUser777" <lax_777@comcast.net> wrote in message
news:1143747084.696808.204150@i39g2000cwa.googlegroups.com...
> Ardus,
>
> do you have anything more solid?
>
> Thanks
> ExcelUser777
>

[ExcelUser777]

Bob, Ardus

Thanks so much for the info...

I actually found it under "Range name in sumif function" ... Under
Google Groups

=SUMIF(IS_UM_Code,$A17,INDIRECT(A1))

Bob that is awesome how you picked apart the range name


Thanks,
ExcelUser777