Fixing part of a range for formula...

[Niemsters]

This may be a simple questions but it has me stumped. Coumn D has a lot of data in it, my formula sums the data starting at D4, EXCEPT for the last 6 rows [=sum(D4:D20)]. I have a macro that inserts new data by INSERTING a row and pasting the new data in. However when I do this my formula 'moves down' and does not include the new row[=sum(D5:D21)]. The bottom 6 rows are still not included. I've tried to use $D$4, or INDIRECT but neither have wored for me. Is there a way to fix the cell reference even when using Instert?

Thanks ahead of time.

 

[Niemsters]

nevermind I figured it out. I used Offset(D3,1,0)...