Hi folks, new to the site. Looks pretty good, I'll give this a go.

I have a named range that skips around, ie. "Foundations" is a1:14,a20:a30
I have another named range like "Carpentry" is a31:a40,a50:a60

On my printout page, I want to be able to type in "Foundations" in cell b1 and have all the relevant data show up. Data for the printout mostly includes summing all the "foundations" data from below into one consolidated sheet.

I have found that if I use =sum(indirect(b1)) it evaluates to a #ref.
If I modify my range so that it does not skip around, it evaluates properly.

Does anyone know how to make this work?
I could easily write a macro to do it, but that would tie me to this file for the rest of my life, as I am the only one around who can program.