How can I calculate averages of blocks of 200 cells? so the first output row shows average of first 200 cells, next output row from cell numbers 201-400, the next 401-600 and so on.
= Average(A1:A200)
= Average(A201:A400)
= Average(A401:A600)
etc.
Sample file attached.
Bookmarks