Named range using indirect and cells containing range strings

Lets say I have a named range , range1 which points to these non-contiguous cells
Summary_Table!$E$11,Summary_Table!$Q$11:$Q$21

Now I have similarly multiple ranges as such. Is there a way to define these named ranges, where I have the ranges in a column.
So lets say A1 contains the string: Summary_Table!$E$11,Summary_Table!$Q$11:$Q$21.

Is there a way to define a named range, range1 pointing to A1 using indirect or something else.

Thanks

Hi Glenn,
The thread is reopened here again. Would you be able to take look. Thanks

Select cell A1, then click on the Name Box, which is to the left of the formula box, then you can enter the name (range1) and press Enter. There should be no spaces in the name - use an underscore instead.

Then you can just enter:

=range1

in a cell somewhere, to reproduce what is in A1.

Hope this helps.

Pete

Hi pete,
This does not work. Once creating ranges as you have suggested, I dont get anything plotted in the charts. Also, if i do sum(range1), it gives 0.

Originally Posted by Melvosh

You can do it with single ranges using INDIRECT, whether they are single cells or multiple cells, but I haven't gotten it to work with multiple non-contiguous ranges yet.

Thanks for answering. Yes, thats my issue, with noon-contiguous ranges. Looks like I have to do it manually

Originally Posted by vikas.trades25

... This does not work. ...

In your first post you asked:

... Is there a way to define a named range, range1 pointing to A1 ...

I gave you one way to do that. You did not say what you wanted to do with it, but I could have told you that:

=SUM(INDIRECT(range1))

would not work, as you need a contiguous range for that to work.

Pete

Originally Posted by Pete_UK

In your first post you asked:



I gave you one way to do that. You did not say what you wanted to do with it, but I could have told you that:

=SUM(INDIRECT(range1))

would not work, as you need a contiguous range for that to work.

Pete

Hi, sorry for any confusion.
I dont want the sum. Was just showing that it sums up to 0. I actually wand to use this named range in plot. Looks like cant do that using a formula.