Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Daily average at the specific date
I want the daily average to appear at the point when the date changes. Is
there a way to do this? For example, lets say I want to use columns A, B, and C. A will obviously contain the date, B will contain the data, and C will contain the average up to (and including) the date it belongs to... Here is an example: 5 Oct | 50 6 Oct | 100 The above example shows columns A and B, and for C1 I want it to average only B1, which would be 50. For C2 I want it to average B2 and everything that occured before then, so B2 and B1 50+100=150 / 2 = 75 (It found the average of B2 and B1)... ....And it would continue on. For C3 I want it to average B3, B2, B1... C4 I want it to average B4, B3, B2, B1.. And it will always continue. Is there a formula I can use for this? Or would I have to manually adjust the average everytime I insert new data? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Daily average at the specific date
In C1 enter the below formula and copy down as required
=AVERAGE($B$1:B1) -- Jacob "KeithD" wrote: I want the daily average to appear at the point when the date changes. Is there a way to do this? For example, lets say I want to use columns A, B, and C. A will obviously contain the date, B will contain the data, and C will contain the average up to (and including) the date it belongs to... Here is an example: 5 Oct | 50 6 Oct | 100 The above example shows columns A and B, and for C1 I want it to average only B1, which would be 50. For C2 I want it to average B2 and everything that occured before then, so B2 and B1 50+100=150 / 2 = 75 (It found the average of B2 and B1)... ...And it would continue on. For C3 I want it to average B3, B2, B1... C4 I want it to average B4, B3, B2, B1.. And it will always continue. Is there a formula I can use for this? Or would I have to manually adjust the average everytime I insert new data? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Daily average at the specific date
Thank you for your help, it works.
"Jacob Skaria" wrote: In C1 enter the below formula and copy down as required =AVERAGE($B$1:B1) -- Jacob "KeithD" wrote: I want the daily average to appear at the point when the date changes. Is there a way to do this? For example, lets say I want to use columns A, B, and C. A will obviously contain the date, B will contain the data, and C will contain the average up to (and including) the date it belongs to... Here is an example: 5 Oct | 50 6 Oct | 100 The above example shows columns A and B, and for C1 I want it to average only B1, which would be 50. For C2 I want it to average B2 and everything that occured before then, so B2 and B1 50+100=150 / 2 = 75 (It found the average of B2 and B1)... ...And it would continue on. For C3 I want it to average B3, B2, B1... C4 I want it to average B4, B3, B2, B1.. And it will always continue. Is there a formula I can use for this? Or would I have to manually adjust the average everytime I insert new data? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas - Daily average at the specific date
You are welcome.
-- Jacob "KeithD" wrote: Thank you for your help, it works. "Jacob Skaria" wrote: In C1 enter the below formula and copy down as required =AVERAGE($B$1:B1) -- Jacob "KeithD" wrote: I want the daily average to appear at the point when the date changes. Is there a way to do this? For example, lets say I want to use columns A, B, and C. A will obviously contain the date, B will contain the data, and C will contain the average up to (and including) the date it belongs to... Here is an example: 5 Oct | 50 6 Oct | 100 The above example shows columns A and B, and for C1 I want it to average only B1, which would be 50. For C2 I want it to average B2 and everything that occured before then, so B2 and B1 50+100=150 / 2 = 75 (It found the average of B2 and B1)... ...And it would continue on. For C3 I want it to average B3, B2, B1... C4 I want it to average B4, B3, B2, B1.. And it will always continue. Is there a formula I can use for this? Or would I have to manually adjust the average everytime I insert new data? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Daily Balance | Excel Worksheet Functions | |||
Daily Average | Excel Discussion (Misc queries) | |||
Average Age of Population on a Specific Date | Excel Worksheet Functions | |||
Running a Daily MTD average. | Excel Worksheet Functions | |||
daily average | Excel Worksheet Functions |