For example
I name A2:A5; "test_a"
I name A6:A10; "test_b"
I want to create a third named range "test_c" which then includes the {sum} area of "test_a" and "test_b"
Context / Rationale
I tried to create a named range that includes many (80 plus) non-contiguous named ranges.
Strangely even...