This formula will *always* start your range at D9:
=SUM(INDIRECT("$D$9"):$D$500)

Note: Inserting rows will extend the range downwards.

Does that help?

Ron