Thursday, May 19, 2011

yogi_Sum Of Specific Columns Based On A Pattern In Each Row

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
Justin Bradley said:
I want to calculate the sum of certain columns for each row. Ex I want =SUM(F8,L8,R8,X8,AD8), then under that I want =SUM(F9,L9,R9,X9, AD9). Is there any way to automate this for each row like =SUM (F*,L*,R*,X*,AD*) where *= the row number?
Well, I noticed the pattern that starting with column F you want to sum up the value in every 8th column in row 8 and once a formulas has been developed do that for row 8, then the formula can be replicated for row 9.