| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Average Formula | Excel Discussion (Misc queries) | |||
| A formula to AVERAGE IF but only average a set number of values | Excel Worksheet Functions | |||
| average in formula? | Excel Discussion (Misc queries) | |||
| Formula for Average | Excel Discussion (Misc queries) | |||
| how does one convert text to a formula "average(A:A)" to =average( | Excel Worksheet Functions | |||
Linear Mode
