Excel Threads - Average function

Report thread as spam

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.

This question was started by nixiguf 2 years ago

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.

This response was posted by nixiguf 2 years ago

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.

This response was posted by joeu2004 2 years ago