Filling Down Cells in a series

[Pope_003]

Hello,

I'm hoping you can assist me with the following query:

As per the attachment I have two columns, Column B contains formulas that I essentially want to be able to fill down without having to add "+previous cells" or change the number of cells to average by.

For example, in Cell B5 if I fill down I get "=SUM(B3+B4+A5)/3" when I actually want it to state "=SUM(B2+B3+B4+A5)/4".

Any help with this would be greatly appreciated.

Thank you,

David

[:) Sixthsense :)]

In B2 Cell

=(A2+SUM($B$1:B1))/(COUNT($B$1:B1)+1)

Drag it down..

[adyteo]

in B4: =SUM(B$2:B3,A4)/(COUNT(B$2:B3)+1) and drag it down

[Pope_003]

Thank you both for your help; that worked perfectly