DS Forums

 
 

Excel for iPad


Reply
Thread Tools Search this Thread
Old 27-01-2016, 09:33
Toby LaRhone
Forum Member
 
Join Date: Mar 2013
Posts: 9,198

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
Toby LaRhone is offline   Reply With Quote
Please sign in or register to remove this advertisement.
Old 27-01-2016, 12:16
Stig
Forum Member
 
Join Date: Sep 2003
Location: Sandy Heath, Beds. UK
Posts: 10,377
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
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.
Stig is offline   Reply With Quote
Old 27-01-2016, 17:34
Toby LaRhone
Forum Member
 
Join Date: Mar 2013
Posts: 9,198
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.
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)
Toby LaRhone is offline   Reply With Quote
Old 27-01-2016, 17:57
Stig
Forum Member
 
Join Date: Sep 2003
Location: Sandy Heath, Beds. UK
Posts: 10,377
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)
You would have to manually edit the range within the formula in each cell. It's a pain to begin with, but then it's done.
Stig is offline   Reply With Quote
Old 27-01-2016, 20:34
oilman
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,
oilman is offline   Reply With Quote
Old 27-01-2016, 22:49
Toby LaRhone
Forum Member
 
Join Date: Mar 2013
Posts: 9,198
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,
Ah! I remember the inclusion of the $ symbol all those years back now.
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!
Toby LaRhone is offline   Reply With Quote
 
Reply




 
Forum Jump


All times are GMT. The time now is 20:03.