Replace text in named range with text extracted from another cell in XL2010

[plateo2000]

Have simple formulas using named ranges to copy down column and would like to replace the last four digits in the named range based on the last four digits in the cell to the left rather than manually changing the year in the named range:

Cells to left:
FYE2006 =sum(adminsalaries2006)
FYE2007 =sum(adminsalaries2007)
FYE2008 =sum(adminsalaries2008)
...

 

[Joe4]

Welcome to the Board!

Let's say that "FYE2006" is in cell A2. Then use this formula for the sum you want:

=SUM(INDIRECT("[COLOR=#333333]adminsalaries[/COLOR]" & RIGHT(A2,4)))

 

[plateo2000]

Thank you Joe4. I have Mr. Jelen's 2010 book now and will dedicate this evening to the exploration of "Indirect."