how can I build a formula where I am calculating cell addresses 1

[crawfme]

I want to be able to build an "average" formula where I am calculating the value of the beginning and ending row to use in the formula. For example, if the formula I want is =AVERAGE(A2:A7) I want to be able to build the formula and calculate the values 2 and 7. If there was a formula in cell C1 that equalled 2 and a formula in cell C2 that equalled 7, then I was thinking I could do something like:

=AVERAGE("A"&C1&":A"&C2)

or

=AVERAGE("A"&TEXT(C1,0)&":A"&TEXT(C2,0))

but neither one works.

Does anyone know how to do this?

 

[SkipVought]

Hi,

Take a look at the INDIRECT function.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[yogia]

Hi crwfme:

If I understand you correctly, you can also use ...

=AVERAGE(ROW(A2),ROW(A7))

Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC

http://www.energyefficientbuild.com