Easy to adapt:

=SUM(D1:INDEX(D:D,ROW()-1))

which is better than having INDIRECT or even OFFSET.

Don Guillett wrote:
not automatic on row insertion