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.


  1. Hey You Are Very Welcome madd ... Now Let Us Keep Googling.