SOLVED! named range drop down list sum index

Ok

I want to make a drop down list that refers to a named range, that would work with my sum index formula.

=SUM(INDEX(B10:BA10,C32):INDEX(B10:BA10,C33))

When I type the named range in (replacing the B10:BA10) it works. But for userability I want a drop down list validation that lets them choose which named range they are looking at.

Any ideas? Really stuck. Thanks,

Assuming the drop box cell were A1, you would add the INDIRECT() function, like so:

=SUM(INDEX(INDIRECT(A1),C32):INDEX(INDIRECT(A1),C33))