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   Apr-20-2014
post by Berker Pekoz: (!category-topic/docs/spreadsheets/J1dj6Xzgx3U)
Average concatenated addresses
I'm trying to average every 5 rows of a column. To denote the dynamic range I do:
that outputs A1:A5 when entered on row #1, A6:A10 on row #2 etc. Since I need 
I input:
However doing so produces a division by zero error. What am I missing?