SOLVED! named range drop down list sum index

[superspurs]

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,