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

Hi Jason,

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

HTH
FxM



Nascent a écrit :

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

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

Thanks! That works like a charm!

Regards,
Jason

FxM wrote in
:

Hi Jason,

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

HTH
FxM



Nascent a écrit :

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