This is a follow on from
https://www.experts-exchange.com/questions/29135421/How-to-create-an-indirect-reference-to-multiple-named-ranges.html
The solutions to that question summed any/all numbers in the tabs.
What I need to do is sum only certain pre-defined areas.
Contra Martin's last posted proposals, I don't want to manually choose the ranges each time, I want the same ranges every time, baked into the code.
Can you replicate the solution to the above question, but applying the summing to ranges: B6:R8; B9:R14; X6:AR8 and X9:AR14.
Is it possible to make one named area for all those ranges together? Would this help?