Frank: thanks! and another query..

[Guest]

Thanks Frank
That helped a lot
Another question.. now.. i need to make the function =AVERAGE(INDIRECT("A1:A" & B1)) be a "run-on" (ie, i want A1 to move on to A2 and A(B1) to be A(B1+1)... how do i do that?

Help greatly appreciated

H
if your value n is stored in cell B1 us
=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
Thanks

 

[Frank Kabel]

Hi
so you want to change the row index then you copy the
formula down?. If yes try
=AVERAGE(INDIRECT("A" & ROW(1:1) & ":A" & $B$1+ROW(1:1)-1))
if I understood you correctly.

-----Original Message-----
Thanks Frank!
That helped a lot!
Another question.. now.. i need to make the function

=AVERAGE(INDIRECT("A1:A" & B1)) be a "run-on" (ie, i want
A1 to move on to A2 and A(B1) to be A(B1+1)... how do i do
that?

Help greatly appreciated!


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!
Thanks!

.

.

 

[Guest]

Thank you very much, Frank!