Average Formula?
 

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

Average Formula?
 

In B1, enter =Average(A1:A$1)

Copy and paste it down B1 or use the fill handle.

"choo" wrote in message
...
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

Average Formula?
 

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

Average Formula?
 

Hi Steve,

Is there a different between =Average(A1:A$1) and =Average(A$1:A1)?

choo


"Steve" wrote:


In B1, enter =Average(A1:A$1)

Copy and paste it down B1 or use the fill handle.

"choo" wrote in message
...
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

Average Formula?
 

Both will do what you want.
..
"choo" wrote in message
...
Hi Steve,

Is there a different between =Average(A1:A$1) and =Average(A$1:A1)?

choo


"Steve" wrote:


In B1, enter =Average(A1:A$1)

Copy and paste it down B1 or use the fill handle.

"choo" wrote in message
...
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