Variable Range
 

Does anyone know how to use variable's to set a range in Excel (Not in code
but actually in cells).

For instance I have a cell that does the following Sum(C8:H8) - Clearly this
sums the information in C8:H8. This represents a January - June data. I have
a million of these "sums" throughout my document and I want to be able to
change it so instead of a looking at 6 months, I could look at 3, 9, or
12...etc

My goal is to have two fields where the user could put the first and second
cell in.
Start
End

I would then put that in the formula (ie. Sum(Variable1: Variable2)), with
the variable representing the actual cell location

Can this be done?

Variable Range
 

Look in the help index for INDIRECT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James C." wrote in message
...
Does anyone know how to use variable's to set a range in Excel (Not in
code
but actually in cells).

For instance I have a cell that does the following Sum(C8:H8) - Clearly
this
sums the information in C8:H8. This represents a January - June data. I
have
a million of these "sums" throughout my document and I want to be able to
change it so instead of a looking at 6 months, I could look at 3, 9, or
12...etc

My goal is to have two fields where the user could put the first and
second
cell in.
Start
End

I would then put that in the formula (ie. Sum(Variable1: Variable2)), with
the variable representing the actual cell location

Can this be done?

Variable Range
 

That is what I was looking for...

Thanks.

"Don Guillett" wrote:

Look in the help index for INDIRECT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"James C." wrote in message
...
Does anyone know how to use variable's to set a range in Excel (Not in
code
but actually in cells).

For instance I have a cell that does the following Sum(C8:H8) - Clearly
this
sums the information in C8:H8. This represents a January - June data. I
have
a million of these "sums" throughout my document and I want to be able to
change it so instead of a looking at 6 months, I could look at 3, 9, or
12...etc

My goal is to have two fields where the user could put the first and
second
cell in.
Start
End

I would then put that in the formula (ie. Sum(Variable1: Variable2)), with
the variable representing the actual cell location

Can this be done?

Variable Range
 

Use
=SUM(INDIRECT(Start&":"&End))
with Start and End being NAMES containing the address of the start/end cells
or
=SUM(INDIRECT(A1&":"&A2))

with A1 containing C8 and A2 containing H8 to SUM(C8:H8)
-------------------------------------
Pl. click ''Yes'' if this was helpful...



"James C." wrote:

Does anyone know how to use variable's to set a range in Excel (Not in code
but actually in cells).

For instance I have a cell that does the following Sum(C8:H8) - Clearly this
sums the information in C8:H8. This represents a January - June data. I have
a million of these "sums" throughout my document and I want to be able to
change it so instead of a looking at 6 months, I could look at 3, 9, or
12...etc

My goal is to have two fields where the user could put the first and second
cell in.
Start
End

I would then put that in the formula (ie. Sum(Variable1: Variable2)), with
the variable representing the actual cell location

Can this be done?