Name Range - Relative Reference

**Sultix** · 12-30-2012, 09:45 AM

Hi,

attached you will find a sample..

Could you please help me out, how can i copy the cell C10 to D10 so that name range changes aswell. When copied the formula with Class1 (Range 1) right next it should sum the name range class2 (Range 2)
I know the name ranges are absolute reference and it cant be modified when copied down.
Is there a trick to make it relative Reference.. i want to keep the added Name Definitions untouched.

Thanks

**benishiryo** · 12-30-2012, 09:51 AM

hi Sultix, you can try:
=SUMIFS(INDIRECT("Class"&COLUMNS($C10:C10)),TYP,$B10)

in fact, SUMIF is sufficient

**Sultix** · 12-30-2012, 10:06 AM

Originally Posted by benishiryo

hi Sultix, you can try:
=SUMIFS(INDIRECT("Class"&COLUMNS($C10:C10)),TYP,$B10)

in fact, SUMIF is sufficient

i get only zero values if i try that formula..
Name Range Class1 (B2:B9)
Name Range Class2 (C2:C9)

I overwrote the text Class with Class1 .. still no correct summing.. any idea where the error is ?