Hello Everyone, thanks in advance for any help!

I have data in column $F that has a row deleted and added every 5min. The column next to $F is calculating a moving average off of it every 5 rows. =average(indirect("A4:A8")) does the trick, but will not autofill down, which would be great because their's 500 rows and several columns. I've tried so many variations of above average with the "&rows()".
for example =average(indirect("f"&row(F4)):indirect("f"&row(F8))) but cant get it to select column $F in its entirety to give a chance. I'm fairly new at excel and have been working on this problem for longer than I'd like to admit.

any help will be appreciated more than you could imagine thanks,
Jeff