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.

On 05/18/2011 12:39 PM, nixiguf wrote:
> 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




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

On May 18, 1:08*pm, nixiguf <nixi...@gmail.com> wrote:
> On 05/18/2011 12:39 PM, nixiguf wrote:
> > 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

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.