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

check INDIRECT

HTH
--
AP

"ExcelUser777" a écrit dans le message de
ups.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

Ardus,

do you have anything more solid?

Thanks
ExcelUser777

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" wrote in message
oups.com...
Ardus,

do you have anything more solid?

Thanks
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