Using dynamic range in functions

rrk · Mar 17, 2004

Hi all,

I have a set of data in one column from row 1 to 100. How can I
calculate the average of the data from row 1 to row i? The value of i
is located in another cell. Thanks in advance.

Debra Dalgleish · Mar 17, 2004

With the variable in cell D1:

=AVERAGE(INDIRECT("A1:A"&D1))

rrk · Mar 17, 2004

Debra Dalgleish said:
With the variable in cell D1:

=AVERAGE(INDIRECT("A1:A"&D1))

Thanks a lot. Using this function made my life much easier.

rrk