software

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,
ExcelUser777check INDIRECT

HTH
--
AP

quot;ExcelUser777quot; gt; a écrit dans le message de ups.com...
gt; Hello,
gt;
gt; I have a named range in the formula below..... BS_UM_0606....
gt;
gt;
gt; =ROUND(SUMIF(BS_Um_Code,'Summary BS'!$A10,BS_Um_0606),0)
gt;
gt;
gt; I have other named ranges for example 0607
gt;
gt; My goal is to enter 0607 in a cell and have the 0606 update to 0607
gt;
gt; Is there a way to update a range name by typing in a new range name in
gt; a cell?
gt;
gt;
gt;
gt;
gt; Thanks,
gt; ExcelUser777
gt;
Ardus,

do you have anything more solid?

Thanks
ExcelUser777Assuming that 0606 is in cell C1 for instance,

=ROUND(SUMIF(BS_Um_Code,'Summary BS'!$A10,INDIRECT(quot;BS_Um_quot;amp;C1)),0)--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;ExcelUser777quot; gt; wrote in message oups.com...
gt; Ardus,
gt;
gt; do you have anything more solid?
gt;
gt; Thanks
gt; ExcelUser777
gt;
Bob, Ardus

Thanks so much for the info...

I actually found it under quot;Range name in sumif functionquot; ... Under
Google Groups

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

Bob that is awesome how you picked apart the range nameThanks,
ExcelUser777