Continuous (not moving) average

[Andies101]

Hi all,

Having trouble finding an answer to what I assume is an easy question. I'm trying to find a formula (that will auto fill) for a continuing average. consider the below table

What formula do I need in C3 to calculate the average of B2+B3 so I can auto fill for the remaining of C, where C4 = (B2+B3+B4)/3, C5 = (B2+B3+B4+B5)/4, C6 = (B2+B3+B4+B5+B6)/5, etc etc

I understand this can be done the long way, calculating each cell, but lets just assume C has over 1500 rows.

Thanks in advance

 

[Z51]

You can use:

=AVERAGE($B$2:B3)

 

[Andies101]

Thanks so much,

I knew there had to be a simple answer. Just couldn't find it.

Ill perform a good deed for someone tomorrow as karmic payment.