In Excel is it possible to create a name range that contains multiple name
ranges. As an example, I have created several name ranges with one cell
reference, such as Sales(A2), COS(A5), ADM(A7), SELLING(A8), MRKT(A9). I
would like to create a name range that I could include the all the name
ranges and call it GROSS_PROFIT. If later I add another range I would like
to be able to just add the range name to GROSS_PROFIT, such as R&D.

Also the reason I chose to use named ranges is my cell references can change
from month to month, I find it easier to create formulas using name
references then redefining the cell reference for the range. Then I could
use a formula like SUM(GROSS_PROFIT), rather than SUM(A2,A5,A7,A8,A9).

Thanks for your help.

Insert|Name|Define
Names in Workbook: Gross_Profit
refers to: =sales,cos,adm,selling,mrkt

When you want to add another range/name, just insert|name and add it.



travis wrote:
>
> In Excel is it possible to create a name range that contains multiple name
> ranges. As an example, I have created several name ranges with one cell
> reference, such as Sales(A2), COS(A5), ADM(A7), SELLING(A8), MRKT(A9). I
> would like to create a name range that I could include the all the name
> ranges and call it GROSS_PROFIT. If later I add another range I would like
> to be able to just add the range name to GROSS_PROFIT, such as R&D.
>
> Also the reason I chose to use named ranges is my cell references can change
> from month to month, I find it easier to create formulas using name
> references then redefining the cell reference for the range. Then I could
> use a formula like SUM(GROSS_PROFIT), rather than SUM(A2,A5,A7,A8,A9).
>
> Thanks for your help.

--

Dave Peterson

Simple solution. Thank you!

"Dave Peterson" wrote:

> Insert|Name|Define
> Names in Workbook: Gross_Profit
> refers to: =sales,cos,adm,selling,mrkt
>
> When you want to add another range/name, just insert|name and add it.
>
>
>
> travis wrote:
> >
> > In Excel is it possible to create a name range that contains multiple name
> > ranges. As an example, I have created several name ranges with one cell
> > reference, such as Sales(A2), COS(A5), ADM(A7), SELLING(A8), MRKT(A9). I
> > would like to create a name range that I could include the all the name
> > ranges and call it GROSS_PROFIT. If later I add another range I would like
> > to be able to just add the range name to GROSS_PROFIT, such as R&D.
> >
> > Also the reason I chose to use named ranges is my cell references can change
> > from month to month, I find it easier to create formulas using name
> > references then redefining the cell reference for the range. Then I could
> > use a formula like SUM(GROSS_PROFIT), rather than SUM(A2,A5,A7,A8,A9).
> >
> > Thanks for your help.
>
> --
>
> Dave Peterson
>