yogi_Compute In Cells C1 C2 Etc Average Of A Group Of Specified Number Of Successive Cells In Column A

                                         Google Spreadsheet   Post  #1607
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-20-2014
post by Berker Pekoz: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/J1dj6Xzgx3U)
Average concatenated addresses

Hello,

I'm trying to average every 5 rows of a column. To denote the dynamic range I do:

=CONCATENATE(ADDRESS((ROW()-1)*5+1,1,4),":",ADDRESS(ROW()*5,1,4))

that outputs A1:A5 when entered on row #1, A6:A10 on row #2 etc. Since I need 

=AVERAGE(A1:A5)

I input:

=AVERAGE(CONCATENATE(ADDRESS((ROW()-1)*5+1,1,4),":",ADDRESS(ROW()*5,1,4)))

However doing so produces a division by zero error. What am I missing?

Regards,

---------------------------------------------------------------------------------------------------------------------------------------------------------