averaging problem

[hoggie]

In column A I have a list of data say from A1-A10, in cell B1 I have the function Average A1-A10. In cell B2 I want to average the next set in column A(A11-A20), is there a quick way to do this I have lots of data in column A so setting the cell range each time is not an option, I want to average the next 10 values in column A and keep going until the column data is complete.

[BigBas]

Enter this formula in cell B1 and fill down as far as necessary. Report back if it works:

=AVERAGE(OFFSET($A$1,(ROW()-1)*10,0,10))

[hoggie]

Thanks the formulae worked a treat.