Sunday, April 20, 2014

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,
---------------------------------------------------------------------------------------------------------------------------------------------------------