Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
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.
THANK YOU SO MUCH!!!
ReplyDeleteHey You Are Very Welcome madd ... Now Let Us Keep Googling.
ReplyDeleteCheers!
Yogi