How to average n cells in column? Excel 2013

[dejana017]

So THE problem is next:
I have 44.525 data in a collumn (B2-B44526), I need a formula to do average for 60 cells ( I mean average from B2:B59, than from B60-B121 etc) all are numbers nothing to skip. So if I want for result to be in cell K3 and below to some K750 (because 44525/60=742 - so that much results i need to have). Please HELP!!!!
Thanks in advance

 

[steve the fish]

Hi. Something like this should work. Im not sure B2:B59 is 60 cells though

=AVERAGE(INDEX($B$2:$B$44526,ROWS($A$1:A1)*60-59):INDEX($B$2:$B$44526,ROWS($A$1:A1)*60))

 

[dejana017]

Thank you, thank you, thank you I've been searching for answer for 2 days! It works.... thank you
And B2:B59 is not 60 cells for sure.

 

[Jonmo1]

Your example ranges don't allign with your expectation of every 60 cells..
B2:B59 is only 58 cells, while B60:B121 is 62 cells.

Anyway, here's another way literally doing every 60 cells beginning with B2.

=AVERAGE(OFFSET($B$2,60*(ROWS($A$1:A1)-1),0,60,1))