averaging from a fixed point to a non-fixed point?

N

Nascent

I have a column that I want to be the average() of another column up to
that point. For example:

a b
1 10 10
2 6 8
3 5 7

You'll notice that the value of bn is the average for everything in col a
up to that point. Thus 8 is (10 + 6) / 2 = 8. But it seems I have to
hand-enter the formula for every cell in b in order to accomplish this.

Is there a better way to do this?

Thanks!,
Jason
 
F

FxM

Hi Jason,

Add a $ sign bfore what shouldn't change.
In b1 : =average($A$1:A1)
copy to bottom.

HTH
FxM



Nascent a écrit :
 
N

Nascent

Gah! I was trying to use ! instead of $. =)

Thanks! That works like a charm!

Regards,
Jason
 
Top