Filldown of formulas problem

[TTom]

I have the following formula in a cell F10:
=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:

 

[Aladin Akyurek]

See my posts in:

http://www.mrexcel.com/board2/viewtopic.php?t=60895

 

[TTom]

Thanks for the link.
After some study I noticed a suggestion about using SUMIF in place of DSUM for certain applications.
It turns out this works perfect for my needs and realized I could use SUMIF to resolve my delima!
It actually elimates the whole DSUM additional data (every other row stuff) a makes fill down easy and possible.

This made my day and I can relax this weekend!!
Many thanks for a good tip

FYI - My new formula filldown looks like this:
where My_Code and My_Amt are named rangeds on another sheet
formula for A10: =SUMIF(My_Code,A10,My_AMT)
formula for A11: =SUMIF(My_Code,A11,My_AMT)
formula for A12: =SUMIF(My_Code,A12,My_AMT)
and so on...