|
||||||||
Excel for iPad |
![]() |
|
|
Thread Tools | Search this Thread |
|
|
#1 |
|
Forum Member
Join Date: Mar 2013
Posts: 9,198
|
Excel for iPad
Is anyone au fait with basic formulas?
I haven't used excel in about 8 years and then on a PC. I want to have a column with running daily average of figures in an adjacent column i.e day1/day2, days1/2/3 etc =AVERAGE(B1:B25) seems to be incorrect typed in C1 and dragged to C25 |
|
|
|
|
Please sign in or register to remove this advertisement.
|
|
|
#2 |
|
Forum Member
Join Date: Sep 2003
Location: Sandy Heath, Beds. UK
Posts: 10,377
|
Quote:
Is anyone au fait with basic formulas?
I haven't used excel in about 8 years and then on a PC. I want to have a column with running daily average of figures in an adjacent column i.e day1/day2, days1/2/3 etc =AVERAGE(B1:B25) seems to be incorrect typed in C1 and dragged to C25 I don't understand what you are trying to achieve anyway. |
|
|
|
|
|
#3 |
|
Forum Member
Join Date: Mar 2013
Posts: 9,198
|
Quote:
If you put the formula =AVERAGE(B1:B25) into C1 and then copy is down the column, the formula in C2 would be =AVERAGE(B2:B26). Is that what you want?
I don't understand what you are trying to achieve anyway. I want each cell in C to show me the accumulated average of the preceding cells in B. Each time a new value appears in B I want the new average ito appear in the C cell Let's say B1 is January and is 100. In June, if B6 is 200 I want C6 to give the average for Jan to Jun and so on every month. (Thanks for replying by the way) |
|
|
|
|
|
#4 |
|
Forum Member
Join Date: Sep 2003
Location: Sandy Heath, Beds. UK
Posts: 10,377
|
Quote:
No.
I want each cell in C to show me the accumulated average of the preceding cells in B. Each time a new value appears in B I want the new average ito appear in the C cell Let's say B1 is January and is 100. In June, if B6 is 200 I want C6 to give the average for Jan to Jun and so on every month. (Thanks for replying by the way) |
|
|
|
|
|
#5 |
|
Forum Member
Join Date: Dec 2002
Posts: 3,851
|
Is this what you want
eg Month Value Running Average Jan 5 5 Feb 7 6 = (5+7)/2 Mar 9 7 = (5+7+9)/3 If so, see https://www.dropbox.com/s/qxc0rtr0uz...rage.xlsx?dl=0 see formula in cell E4 =AVERAGE(d$4:d4) This formula is just copied into rows below so E5 becomes =AVERAGE(d$4:d5) and so on. ie first point is anchored, but second point is relative Even if not exactly what you want, gives the principle of how to do it, |
|
|
|
|
|
#6 |
|
Forum Member
Join Date: Mar 2013
Posts: 9,198
|
Quote:
Is this what you want
eg Month Value Running Average Jan 5 5 Feb 7 6 = (5+7)/2 Mar 9 7 = (5+7+9)/3 If so, see https://www.dropbox.com/s/qxc0rtr0uz...rage.xlsx?dl=0 see formula in cell E4 =AVERAGE(d$4:d4) This formula is just copied into rows below so E5 becomes =AVERAGE(d$4:d5) and so on. ie first point is anchored, but second point is relative Even if not exactly what you want, gives the principle of how to do it, That definitely rings a bell. And your example is what I want thanks. Thanks to both of you. I shall go and dabble. ![]() Edit: I forgot to Send the above about 30 mins ago. Since then the problem is solved thanks to the example above ![]() Cheers! |
|
|
|
![]() |
|
All times are GMT. The time now is 20:03.


