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.

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.

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!