Dynamically set a range?

B

BKGT

Is there a way to dynamically set a range? For instance... can I have
formula that includes a range (Ax:Ay) where I can set the values of
and y based on the value of another cell so that in one case, the rang
may be A1:A80 and in another it may be A50:A60 and so on?

Thanks
 
R

Richard Buttrey

Is there a way to dynamically set a range? For instance... can I have a
formula that includes a range (Ax:Ay) where I can set the values of x
and y based on the value of another cell so that in one case, the range
may be A1:A80 and in another it may be A50:A60 and so on?

Thanks.
Click to expand...

Use the Indirect Function

If your x & y variable cells are say B1 & B2

then with B1=50 and B2=60 and if (say) you're summing A50:A60, your
formula would be

=SUM(INDIRECT("A"&B1&":A"&B2))

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
 
Top