Using Formulas to Return a Range

[Peter Bernadyne]

Hello,

I am trying to define a range using a cell containing a formula whic
returns a concatenation of the range arguments I would like to use fo
a worksheet function.

For instance, in one cell, I have the formula:

="C"&TOP

and another I have

="D"&BOTTOM

where 'TOP' and 'BOTTOM' are names I have defined to equal values lik
3 and 200. I am trying to use a worksheet function, lik
CORREL(C3200) using these formulas but I can't seem to get it to wor
for some reason.

I am using these formulas because my range will vary, so it won'
always be C3200.

Does anybody have a clue as to how one could make this work?

Any help is much appreciated!!

Thanks,

-Pete

 

[Frank Kabel]

Hi
use INDIRECT for this. e.g.
=SUM(INDIRECT("C" & Top & "" & Bottom))

 

[Peter Bernadyne]

Actually, I just realized that I need to use arrays with a workshee
function such as CORREL, so this would be:

CORREL(C3:C200,D3200)

instead of what I had before. However, my problem remains the same.
Somehow, this doesn't work.

Thanks,

-Pet

 

[Peter Bernadyne]

Thank you very much!!

This worked just fine.

-Pete