For each row i in col G I'd like to place (the sum of the values in col F
from rows 1 to i) divided by i. Can someone show me how to do that?

You don't really need a macro for this:

G2: =sum(F$2:F2)/count(F$2:F2)

And copy the value down as needed.


"grok" wrote:

For each row i in col G I'd like to place (the sum of the values in col F
from rows 1 to i) divided by i. Can someone show me how to do that?

One way:

Dim i As Long
i = Range("F" & Rows.Count).End(xlUp).Row
With Range("G1").Resize(i, 1)
.Formula = "=F1/" & i
.Value = .Value
End With

In article ,
grok wrote:

For each row i in col G I'd like to place (the sum of the values in col F
from rows 1 to i) divided by i. Can someone show me how to do that?