Name range within a name range

[Guest]

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]

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.

 

[Guest]

Simple solution. Thank you!

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.