Referencing problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
Click to expand...
variable somewhere to be input by user..
how do i get EXCEL to accept the value of "n" and force
Click to expand...
it to do the averaging process? A(n) doesn't work!
 
Back
Top