autofill indirect formula with moving average

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

hi, thanks for your response and yes that is correct. I need formulas to stay in column F in original rows, after deleting or adding a row in column F.
I tried =AVERAGE(INDIRECT("F:F")&ROW(f4:f8)) it averages right and autofills, but after rows are deleted and added I get #ref! error.

Hey, that's okay. thank you very much for your efforts and have a good one!