Sunday, June 5, 2011

yogi_Increment Row References In A Formula By A Specified Number

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  
ClaudioFlabarra said:
How do I increment a formula by more than 1 (i.e. 7)?
I keep a spreadsheet to manage business income. One sheet has each row for daily values, and another sheet has each row for a weekly summary. For the first week, I defined the range on my own... but I can't click and drag the formula for other weeks. The click-and-drag operation increments by 1, and I want it to go by 7. What is the easiest way to do that?
Claudio further added ...
I thought that two rows worth of entries would help Google Spreadsheets infer what I was after, but I was proven wrong. To illustrate:
The two sheets I have are called "Raw Data" and "Weekly". In the weekly spreadsheet, cell C2 is defined as: "=Sum('Raw Data'!C2:C8)", and C3 is defined as: "=Sum('Raw Data'!C9:C15)"; But when I click and drag, cell C4 is automatically filled in as: "=Sum('Raw Data'!C4:C10)" but what I'm after is "=Sum('Raw Data'!C16:C22)"