Average function

[nixiguf]

Suppose I have

A B
3 3
2
4
3
6
4


I want Bn =Average(A1:Bn) for each n = 2, 3, ,,6.


What function do I use in B2 so that I can just copy and paste to
B3 to B6?

Thanks.

 

[nixiguf]

Suppose I have

A B
3 3
2
4
3
6
4


I want Bn =Average(A1:Bn) for each n = 2, 3, ,,6.

Sorry. I meant Bn=Average(A1:An), n = 2,3,..,6

 

[joeu2004]

Sorry. I meant Bn=Average(A1:An), n = 2,3,..,6

Put the following into B1 and copy down:

=AVERAGE($A$1:A1)

The $A$1 will remain unchanged, and A1 will change to A2, A3, etc.