Saturday, January 5, 2013

yogi_Compute Row By Row Average Considering Every Nth Column of An Open Ended Range

                                          Google Spreadsheet   Post  #956
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI    Jan 05, 2013
user collin.m.barrett said:(!category-topic/docs/spreadsheets/0StscdBKHo0)
SELECT every nth cell in a row 

I am using equations similar to the following to select the values in every 5th column of a given row. Is there a way to do this dynamically rather than typing in each individual cell reference? Thanks.

following is a solution to a bit more generalized proble