Linking a range in a formula to other cells

[Tuneman]

I want a cell to calculate the average of a range of numbers in the same column. However I want that range to depend on the values of other cells.

So for example I want the formula in C1 to be: =average(C&value(A1),C&value(a2))

So if A1 = 3 and A2 = 5 then the fomula for C1 would become =average(c3:c5)


Is there any way to do this without a Macro?

I hope that makes sense!

Thanks.

[teylyn]

try

=average(indirect("C"&A1),indirect("C"&a2))

[DonkeyOte]

Or, if preferred in Non-Volatile form (using INDEX):

=AVERAGE(INDEX(C:C,A1):INDEX(C:C,A2))