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
|