Referencing problem

[Constructor]

Hello,
I would like to use the AVERAGE function.

AVERAGE (A1: A(n)) [ sic ] ----->where n is a variable somewhere to be input by user.

how do i get EXCEL to accept the value of "n" and force it to do the averaging process? A(n) doesn't work

Thanks!

 

[Frank Kabel]

Hi
if your value n is stored in cell B1 use
=AVERAGE(INDIRECT("A1:A" & B1))

-----Original Message-----
Hello,
I would like to use the AVERAGE function..

AVERAGE (A1: A(n)) [ sic ] ----->where n is a

variable somewhere to be input by user..

how do i get EXCEL to accept the value of "n" and force

it to do the averaging process? A(n) doesn't work!