Average function

  • Thread starter Thread starter nixiguf
  • Start date Start date
N

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.
 
Sorry. I meant Bn=Average(A1:An), n = 2,3,..,6
Click to expand...

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.
 
Back
Top