choo:
try,
i = 1
Do While Cells(i, 1) < ""
Cells(i, 2).Formula = "=AVERAGE(A1:A" & i & ")"
i = i + 1
Loop
--
天行健，君*以自強不息
地勢坤，君*以厚德載物
http://www.vba.com.tw/plog/
"choo" wrote:
Hello,
I want to calculate the average amount of a growing column A. Column A is
the amount and column B is the corresponding average of total column A until
that row. How is the formula look like?
A B
2 2
3 2.5
1 2
5 2.75
4 3
Thank you.
choo