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.