#### TTom

##### Well-known Member

- Joined
- Jan 19, 2005

- Messages
- 518

=DSUM(L_dBase,6,LEDGER!$G3:$G4)

If I use a normal 'filldown' technique to create the formulas below first, I would have following sequence:

formula in cell F10: =DSUM(L_dBase,6,LEDGER!$G3:$G4)

formula in cell F11: =DSUM(L_dBase,6,LEDGER!$G4:$G5)

formula in cell F12: =DSUM(L_dBase,6,LEDGER!$G5:$G6)

and so on...

I need the cells to sequence in each row, same column as follows:

formula in cell F10: =DSUM(L_dBase,6,LEDGER!$G3:$G4)

formula in cell F11: =DSUM(L_dBase,6,LEDGER!$G5:$G6)

formula in cell F12: =DSUM(L_dBase,6,LEDGER!$G7:$G8)

and so on...

Note how normal filldown technique increases the value of row G in the formula by a value of 1.

Here is my problem, I need the row value of G to increase by 2, not 1, as shown in 2nd sequence.

Any ideas or suggestions on how to do this? I've got hundreds of rows, so this could save me a lot of time. :wink: