Average every 10 cells

[chuckdee]

I have over 40k cells and I want to average every 10 cells. I have data for hours divided within 5 minute increments for 3 months. There must be an easier way.

[NBVC]

Try:

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

where $A$1 represents first cell in the range...