In Excel 2007 and Google Sheets, I'm trying to drag a formula to populate cells in a column, but I need each successive row to have the cell references incremented by seven rows. For example, drag this formula:

```
=((E19-E12)+(F19-F12)+(G19-G12)+(H19-H12))*10,0)
```

down to produce:

```
A22=((E19-E12)+(F19-F12)+(G19-G12)+(H19-H12))*10,0)
A23=((E26-E19)+(F26-F19)+(G26-G19)+(H26-H19))*10,0)
A24=((E33-E26)+(F33-F26)+(G33-G26)+(H33-H26))*10,0)
```

and so on. Therefore increasing the row number by 7 each time. (daily readings added to weekly readings)