Help with function average

[Marcus1997]

Please, I'm needing to create a sequence of averages. for example, I need the first to go from A1: A5, right after A6: A10, A11: A15 .... How do I get Excel to understand this formatting?

[#2 · Accepted solution]

@Marcus1997 

You may try something like this...

=AVERAGE(OFFSET($A$1,(ROW(A1)-1)*5,0,5))

and then copy it down.

[#3]

Thanks for your help. It was very efficient for me.

[#4]

You're welcome @Marcus1997! Glad it worked as desired.