How to use the content of one cell for naming another cell

[Itay]

How to run a function like AVERAGE on 10, 100, ...n cells by
formula/macro that will use the content of one cell (let say $A$1 = n
so that the Average in cell A2 will be calculate the values from $B$
till $B$

 

[Frank Kabel]

Hi
try
=AVERAGE(INDIRECT("B1:" & A1))

 

[Ragdyer]

Try this:

=AVERAGE(INDIRECT("B1:B"&A1))

 

[CLR]

=AVERAGE(INDIRECT("B1:"&"B"& A1))

Vaya con Dios,
Chuck, CABGx3

 

[Aladin Akyurek]

Faster alternative...

=AVERAGE($B$1:INDEX(B:B,A1))