Filling series with averge function of cell blocks

[Prevost]

Hi There. I need to take the average of cells in column A, but I need to take them for rows 1-5, 6-10, 11-15....etc. Does anyone know how I can quickly do this with a fill? Or a work around for this? I tried manually typing in for a few cells AVERAGE(A1:A5) then AVERAGE(A6:A10) and so on but it doesn't seem to work. Does anyone have any ideas? Thanks!

 

[undercookdpork]

Yes! Thank you so much. I really appreciate it. This is exactly what I needed. I was unfamiliar with the row function and kept messing up the row argument, but understand exactly what's going on now. Thanks again.

 

[jim may]

Thanks for response. Glad it works & that you understand it. Jim