Moving Average

Hi, I'm fairly new to using Excel and only know very, very basic stuff.

I have 8,760 bits of data all in one column and I am trying to take the mean of every 24 concecutive cells,

e.g. the mean for cells C7 to C30,
then the mean for cells C31 to C54,
then the mean for cells C55 to C78, etc..... all the way to C8766.

What is the simplest method of doing this? The only way I know is to do something like this: =AVERAGE(C7:C30) manually for every 24 cells as filling doesn't seam to work. I know there must be a better way. Any help would be greatly appreciated.

Thanks Screamer.

Try this formula in D7 copied down

=AVERAGE(OFFSET(C$7,(ROW()-ROW(D$7))*24,,24,))

D7 will give average of the 1st 24 cells, D8 the average of the next 24 and so on.....

Note: the D$7 part ought to match your start cell if you use a start cell other than D7

Thanks, it worked well, a lot easier that way.

Screamer